topic Re: Create table with selections in QlikView

Create table with selections

Anonymous — Mon, 06 Aug 2012 10:57:50 GMT

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

Re: Create table with selections

Mon, 06 Aug 2012 11:01:48 GMT

you mean : only customer is the dimension?

Re: Create table with selections

Anonymous — Mon, 06 Aug 2012 11:39:39 GMT

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

Re: Create table with selections

Mon, 06 Aug 2012 12:07:28 GMT

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

Re: Create table with selections

Anonymous — Mon, 06 Aug 2012 12:09:14 GMT

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.

Re: Create table with selections

Anonymous — Mon, 06 Aug 2012 12:10:50 GMT

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

Re: Create table with selections

Mon, 06 Aug 2012 12:28:10 GMT

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

Re: Create table with selections

Anonymous — Mon, 06 Aug 2012 12:53:57 GMT

Here you are.

Re: Create table with selections

Mon, 06 Aug 2012 13:10:25 GMT

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

Re: Create table with selections

Anonymous — Mon, 06 Aug 2012 13:50:00 GMT

Thanks for helping me.

Cheers,

Henco