Year and Month from the source table

[#1]

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.

[#2]

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.