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.
