Excel Style - Pivot

Sat, 08 Aug 2009 02:50:39 GMT

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

Excel Style - Pivot

Anonymous — Sat, 08 Aug 2009 07:37:32 GMT

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.

Excel Style - Pivot

Sat, 08 Aug 2009 12:21:06 GMT

Hi Clara,

See the attached QV file it may help you.

Thanks

Saran.

topic Excel Style - Pivot in QlikView

Excel Style - Pivot

Excel Style - Pivot

Excel Style - Pivot