Date

Thu, 12 Feb 2015 04:26:28 GMT

I Everyone ,

There is a table by name "COSB_New " and the and the contenet within the table are like this

[Val/COArea Crcy_WKG001],

[Val/COArea Crcy_WKG002],

[Val/COArea Crcy_WKG003],

[Val/COArea Crcy_WKG004],

[Val/COArea Crcy_WKG005],

[Val/COArea Crcy_WKG006], all this fileds content numerical values ,

As per the requirement what i did is :

[Object number_OBJNR] ,

//[Trans. Currency_TWAER],

[Val/COArea Crcy_WKG001] as Apr,

[Val/COArea Crcy_WKG002] as May,

[Val/COArea Crcy_WKG003] as Jun,

[Val/COArea Crcy_WKG004] as Jul,

[Val/COArea Crcy_WKG005] as Aug,

[Val/COArea Crcy_WKG006] as Sep,

[Val/COArea Crcy_WKG007] as Oct,

[Val/COArea Crcy_WKG008] as Nov,

[Val/COArea Crcy_WKG009] as Dec,

[Val/COArea Crcy_WKG010] as Jan,

[Val/COArea Crcy_WKG011] as Feb ,

([Val/COArea Crcy_WKG012] +

[Val/COArea Crcy_WKG013]+

[Val/COArea Crcy_WKG014]+

[Val/COArea Crcy_WKG015]+

[Val/COArea Crcy_WKG016]) as Mar

after doing this i used cross table to get apr, may,jun..... as a content of the month .

Now i have like this :

Month

APr,

May,

Mar,

There is one more table by name ZBKREG which is indirectly connected to this COSb _ NEW table .

I wanted to know what do we need to do so that qlikview recognises that the conversion of months in above table are date function.

Becuase in the ZKBREG there is a date column which has Fiscal Month , Fiscal Year . I want the month column should act like the same .

i hope iam clear.

Re: Date

marcus_sommer — Thu, 12 Feb 2015 15:52:58 GMT

After your crosstable-load you could use a pick(match()) to transform your month:

pick(match(Month, Apr, .....), 4, ......) as Month // or maybe

pick(match(Month, Apr, .....), '04/01/2014', ......) as Date

- Marcus