Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All:
My client store Year and month in the following way.
For a given year, they create 48 month bucket and store values in them , for eg.
for Year 2010, table structure is
Deptid Year Value1 Value2 Value3......Value12 Value13 Value 14.............Value24 Value25.....
1 2010 100 200 300 400 500 600 700
Value1 contains the value for 2010 Jan
Value2 contains the value for 2010 Feb
similarly
Value12 contains the value for 2010 Dec
Value 13 contains the value for 2011 Jan
Value 14 contains the value for 2011 Feb
This structure will change in after every 48 months
so in 2014, values will be stored as
Deptid Year Value1 value2 Value 3
1 2014 100 200 200
now for my dashboard, i need Year and Month and display value for Year and month selection.
How can i achieve this in QlikView.
Thanks for your help.
Thanks for your response.
I tried corss table prior to posting the problem.
I don't think Cross table will work because cross table will give me values as
Year Month Data
2010 Value1 100
2010 Value1 200
2010 Value1 300
.
.
2010 Value13 500
2010 Value14 600
now how do i display Value13 as Jan 2011 and so on
After cross table, i also tried like the following
(if Month = Value 13 then Jan 2011) as ActualMonth_1
(if Month = Value 14 then Feb 2011) as ActualMonth_2
but this will not show continous calendar. It shows ActualMonth_1 and nulls for other months
then it shows ActualMonth_2 and shows nulls for all the other month.