Excel Style - Pivot

[#1]

Hi Guys,

In Excel, the distinct data in a column in table can be made as columns when we create pivot table.

For example: - In the below table i have three columns Type, Month and Count

Type	Month	Count
A	2009-05	1
A	2009-07	2
A	2009-06	3
B	2009-05	4
B	2009-06	5
C	2009-05	6
D	2009-05	7
C	2009-06	8

The Type is having values like A, B, C ,D and month like 2009-05, 2009-06, 2009-07

We can make a pivot like the one below where in distinct months are being displayed in separate columns and their respective sum(Count) is being listed for each Types.

Sum of Count	Month
Type	2009-05	2009-06	2009-07	Grand Total
A	1	3	2	6
B	4	5		9
C	6	8		14
D	7			7
Grand Total	18	16	2	36

Is this possible in QlikView.

Regards,

Clara

[Anonymous]

Clara,
It looks like typical QV pivot table with dimensions Type (on the left) and Month (on top), and one expression sum(Count). To show totals, check "show partial totlas" for both dimensions.

[#3]

Hi Clara,

See the attached QV file it may help you.

Thanks

Saran.