topic Re: Pivot Table - Calculate Percentages in QlikView

Pivot Table - Calculate Percentages

pauledrich — Mon, 22 Jul 2013 19:31:46 GMT

Hi and thank you in advance..

I have a Pivot table which is calculated from the load script with a cumulative last day of the month value Flag - I want to calculate % +or-.

EG...

Regions Sales 1 Sales 2 % +/-

Region 1 100 90 ?

Region 2 200 210 ?

Region 3 150 131 ?

Should this be done in the load script (If so how)?

Better as an expression calculation!

I have explored Column (1) / Column (2) - with no result.

laujerry — Tue, 23 Jul 2013 01:35:23 GMT

sorry, what is ur expected result?

Tue, 23 Jul 2013 07:01:10 GMT

if Sale2 and Sale1 are your fields,

then try this

(Sale2 - Sale1)/Sale1

or try this

(sum(Sale2) - sum(Sale1))/sum(Sale1)

*******************************************

and in number tab check the percent option

er_mohit — Tue, 23 Jul 2013 07:06:52 GMT

make sure your sale 1 and sale 2 is enclosed with sum() function like this

sum(Sale1)

and same for

sum(Sale2)

so for third expression column(2)/Column(1) which you want and for this in number tab for this column fixed to 2 and check on show in %

hope it helps if you want variance % then try this

(column(2)-column(1))/Column(1)

Tue, 23 Jul 2013 07:53:00 GMT

Num((sum(Sale2) - sum(Sale1))/sum(Sale1),'#,##0% ')

(sum(Sale2) - sum(Sale1))/sum(Sale1)

& in number tab check the percent option