I have a budget data in Excel in which the format is 'mmm-yy' ,when I load the budget data in qlikview by using cross table concept then it convert into number format, My problem is that I want to convert it in date format but it is not converting in date format in qlikview.
Please see the budget data and application in attachment.
is the following line causes the Problem?
Date#(MonthYear) as MonthYear1 ,
the date# function formats a given string to a date Format and requires the Format to convert
you Need to tell qlikview to Show the date (in number) as date format
that's the Problem?
When load it using Cross Table then it will read as text instead of num there for you have to use NUM#()
to again convert it into Number.
CrossTable(Date, Data, 3)
(ooxml, embedded labels, header is 3 lines, table is Pulp);
Date(Num#(Date, '##')) as Date,
DROP Table Table;