Year and Month from the source table

Tue, 11 Jun 2013 19:03:43 GMT

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.

Re: Year and Month from the source table

Tue, 11 Jun 2013 20:01:18 GMT

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.