topic Adding Column Measure in QlikView

Adding Column Measure

vikas_nandanwar — Thu, 21 Dec 2017 06:49:27 GMT

Hi,

I have auto date month and Week as two separate columns

I require a new column measure to be added to the data calculated as =

Date Month + week

Example

Date= 2 jan

Week = 1

My new column name should be = Month+Week

Answer = Jan1

Thanks,

Vikas

Re: Adding Column Measure

kaushiknsolanki — Thu, 21 Dec 2017 06:55:18 GMT

Hi,

Simply use preceding load in script like below.

Load *,Month&Week as Newfield;

Load Date,Month,Week from xyz;

In front end (on visualization) you can add dimension as

Month&Week

Regards,

Kaushik Solanki

Re: Adding Column Measure

vikas_nandanwar — Thu, 21 Dec 2017 06:59:35 GMT

The below is my script

LIB CONNECT TO '198.7.112';

Join

LOAD GroupNm,

CategoryNm,

SubCategoryNm,

SizeNm as Size,

QualityNm as Quality,

OGC,

Ptype,

InventoryQty as Qty,

StockValueInDollar as CostAmount,

WkClosingdate as TransactionDate,

DataWeek;

SQL SELECT GroupNm,

CategoryNm,

SubCategoryNm,

SizeNm,

QualityNm,

OGC,

Ptype,

InventoryQty,

StockValueInDollar,

MemoOut,

MemoIn,

WkClosingdate,

DataWeek

FROM dbCertifiedInventory.dbo."vw_DailyInventoryUpload834";

I need to concatenate -

WkClosingdate as TransactionDate,

and DataWeek;

Re: Adding Column Measure

Anil_Babu_Samineni — Thu, 21 Dec 2017 07:03:15 GMT

Do you mean this?

LIB CONNECT TO '198.7.112';

Join

LOAD GroupNm,

CategoryNm,

SubCategoryNm,

SizeNm as Size,

QualityNm as Quality,

OGC,

Ptype,

InventoryQty as Qty,

StockValueInDollar as CostAmount,

WkClosingdate & DateWeek as TransactionDate;

SQL SELECT GroupNm,

CategoryNm,

SubCategoryNm,

SizeNm,

QualityNm,

OGC,

Ptype,

InventoryQty,

StockValueInDollar,

MemoOut,

MemoIn,

WkClosingdate,

DataWeek

FROM dbCertifiedInventory.dbo."vw_DailyInventoryUpload834";