Create table with selections

[Anonymous]

Hi,

Could anybody please tell me if it is possible to build a table like this in QlikView:

CUSTOMER	Total 2011	Jan-11	Feb-11	Mrt-11	Total 2012	Jan-12	Feb-12	Mrt-12	Grand total	Difference

Selection on month should be working.

Hope anyone can help me.

Kind regards,

Henco

[#2]

you mean : only customer is the dimension?

[Anonymous]

Correct Pari Pari. Only customer is dimension.

Imagine this was a table in QV, then I made this selection: month: 1, 2, 3. The rest of the columns will be shown after that. When I select month 4, 5, 6 (or 5 and 6 or only 6) then I would like to see the same columns, but in stead of jan-11 untill mrt 11 and jan 12 untill mrt 12 I would like to see apr-11 untill jun-11 and apr-12 untill jun-12.

Cheers,

Henco

[#4]

how big is you Date range set? How many months?

[Anonymous]

I would like to compare current year versus last year. So for now I would like to see the months 1 - 8 of the years 2011 and 2012 and compare these two.

Compare based on each month and totals for a year. In the last column I would like to see the difference between 2012 and 2011.

[Anonymous]

I found out I can do this the following way: make an expression for each month (1-12 for 2011 and 1-12 for 2012) and show these columns based on selections made in Month field. But I think there will be an easier way to this

[#7]

can you define all the columns (max set) in chart using set analysis and post a qvw file here?

[Anonymous]

Here you are.

[#9 · Accepted solution]

you can do it that way:

change pivot to straight table

put show condition to each column like :

Index(GetFieldSelections(MonthYear,';',24),'01-2011')   <------02-2011, 03-2011 etc

[Anonymous]

Thanks for helping me.

Cheers,

Henco