topic How to create this pivot table ? in QlikView

How to create this pivot table ?

Fri, 03 Aug 2012 20:05:59 GMT

I would like to convert table 1 to table 2 format :

Table 1 :

Customer	Curr Total	Prev Total	Delta Total	Curr Cr	Prev Cr	Delta Cr	Curr Dr	Prev Dr	Delta Dr
Cust 1	350	250	100	550	500	50	-200	-250	50
Cust 2	100	90	10	100	100	0	0	-10	10

Table 2 :

Customer		Current	Previous	Delta
Cust 1	Total	350	250	100
	Cr	550	500	50
	Dr	-200	-250	50
Cust 2	Total	100	90	10
	Cr	100	100	0
	Dr	0	-10	10

Thanks.

Re: How to create this pivot table ?

MayilVahanan — Fri, 03 Aug 2012 20:13:27 GMT

Where Cr and Dr are field value?

If so,

Use like this,

Customer and FieldName(which contain Cr,Dr) as Dimension

Use expression as: =Current,Previos ,Delta as expression use setanalysis if FieldName(which contain Cr,Dr) also contain more value. like sum({<FieldName = {'Cr','Dr'}>}Sales)

And in presentation tab,select Sub total -> on Top for Customer and Dimension , for FieldName(which contain Cr,Dr) set label as blank

Hope it helps