topic Re: Groupping Total in Pivot table in QlikView

Groupping Total in Pivot table

vikasmahajan — Wed, 17 Jun 2015 07:04:30 GMT

Dear all

I have following type of pivot table for calculating P&L

GROUP	TYPE	AMOUNT
A	INCOME	58000
B	EXPENSE	45000

TOTAL(A-B)		13000

In pivot table I want to display (A-B) total how to achieve the same .

Thanks in adv

Vikas

Re: Groupping Total in Pivot table

avinashelite — Wed, 17 Jun 2015 07:12:53 GMT

Hi Vikas,

If you want to added it as a new column they you can simply added it as expression but if you want it as a row value then try with the rangesum() and above() combination to get read the previous value and get the difference out of it

Re: Groupping Total in Pivot table

PrashantSangle — Wed, 17 Jun 2015 07:25:20 GMT

Hi,

Try in expression column

sum(if(wildmatch(Type,'Expense'),Amount * -1,Amount))

and if you dont want show Expense amount in negative then go to Number tab select Integer/Fixed to

and set below pattern

#,##0.00;#,##0.00;

Regards

Re: Groupping Total in Pivot table

Anonymous — Wed, 17 Jun 2015 12:09:49 GMT

Hi Vikas

Here is solution (data file was connected with qvw).

Regards, Alex

Re: Groupping Total in Pivot table

vikasmahajan — Tue, 23 Jun 2015 06:54:04 GMT

Thanks to all how has replied ,

I have Create Dummy Scenario for the same Find attached QVW with my requirement can any one tell me how to achieve the same .

Total

C = A + B

in pivot table.

Thanks

Vikas