How to create a pivot table

[#1]

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

[#2]

Hi,

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

[#3]

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

[#4]

Hi,

Can you post your sample excel file

[#5]

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.