topic Re: Re: How to create a pivot table in QlikView

How to create a pivot table

Wed, 25 Sep 2013 04:03:57 GMT

I would like to build a pivot with 3 variables : Month as Column, Q1 as Row, SurveyCode as filter. Please help me. example below. Survey Code: Q1 Mar Apr May Jun 0 1 5 5 5 1 0 0 1 1 2 0 1 0 2 3 0 1 0 2 4 0 2 1 1 5 3 12 10 8 6 1 10 11 5 7 4 5 14 9 8 1 22 11 16 9 1 1 3 4 10 1 9 9 7 Grand Total 12 68 65 60

Re: How to create a pivot table

Wed, 25 Sep 2013 05:20:03 GMT

Hi,

Very difficult to understand your requirement. If possible post your sample file

Re: Re: How to create a pivot table

Wed, 25 Sep 2013 07:13:28 GMT

Survey Code	CGCRM
Count of Q1	Column Labels
Row Labels	2	3	4
0	1	5	5
1	1
2	1
3	1
4	2	1
5	3	12	10
6	1	10	11
7	4	5	14
8	1	22	11
9	1	1	3
10	1	9	9
Grand Total	12	68	65

This is my pivot in excel, which I want to replicate in Qlikview

Re: How to create a pivot table

Wed, 25 Sep 2013 07:42:52 GMT

Hi,

Can you post your sample excel file

Re: How to create a pivot table

Wed, 25 Sep 2013 08:49:33 GMT

It looks like you need to set up the pivot table as follows:

Add both Q1 and Month as an expression to your table

Add Count(Q1) as an expression to your table

When you look at the table you can readjust the column Month by clicking on it (and holding the mouse button).

You can drag Month to the top of the table.

Now I'm not really sure what you'd like to do with the Survey code.

But it looks like you want to show the results per survey code.

Try adding the Survey code as a dimension and put it in front of the other dimensions.