Date

[#1]

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.

[marcus_sommer]

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