topic Self load in QlikView

Self load

Fri, 08 Jul 2011 13:11:44 GMT

Hi,

I'm not sure if this is possible, i wanted to do mass formatting, instead of doing one by one,

So, im trying to do the following in one single QVW. but it doesn't work for me.

Any tips?

PIVOT:

LOAD SALES,

MONTH_YEAR

FROM XX;

STORE PIVOT INTO PIVOT.QVD;

FORMATTING:

LOAD SALES,

date#(MONTH_YEAR)

FROM PIVOT.QVD;

STORE FORMATTING INTO PIVOT.QVD;

Re: Self load

nagaiank — Fri, 08 Jul 2011 13:25:17 GMT

Try the following script and see if it does what you want to do. (Change the MONTH_YEAR pattern depending on your data)

PIVOT:

LOAD SALES, Date#(MONTH_YEAR,'the pattern of your MONTH_YEAR data') as MONTH_YEAR;

LOAD SALES,

MONTH_YEAR

FROM XX;

STORE PIVOT INTO PIVOT.QVD;

FORMATTING:

LOAD SALES,

date#(MONTH_YEAR)

FROM PIVOT.QVD;

STORE FORMATTING INTO PIVOT.QVD;

Self load

Anonymous — Fri, 08 Jul 2011 13:29:15 GMT

The missing part, regardless if anything else is correct or not:
date#(MONTH_YEAR) as MONTH_YEAR