topic %age in pivot table in QlikView

%age in pivot table

musketeers — Mon, 01 Sep 2014 13:12:39 GMT

Hi,

Need to calculate %age in pivot table. Consider this situation in excel (for example):

Sum of Quantity
Product_Info	Model_Info	Total
Product-1	Model-1	100
Model-2	150
Model-3	12
Model-4	70
Model-5	50
Model-6	200
Product-1 Total		582
Product-2	Model-1	450
Model-2	500
Model-3	230
Model-4	100
Model-5	90
Model-6	40
Product-2 Total		1410
Product-3	Model-1	34
Model-2	45
Model-3	23
Model-4	67
Model-5	500
Model-6	56
Product-3 Total		725
Grand Total	2717

Now for each Model in product I need to calculate percentage like for Model 1 in Product 1 the formula will be Total of Model 1 divided by Product-1 Total. ( 100/582) In the same way for other models.

Please guide me how we can do it in Qlikview.

Thanks

Rajneesh

Re: %age in pivot table

senarath — Mon, 01 Sep 2014 13:21:29 GMT

Hi,

Hi you can select show Relative and get the percentage. So duplicate the same expression and modify it to show relative and check show values in data points,etc.

thanx

Re: %age in pivot table

MK_QSL — Mon, 01 Sep 2014 13:22:58 GMT

Use below expression

SUM(Total)/SUM(TOTAL <Model_Info> Total)

SUM(Value)/SUM(TOTAL <Model_Info> Value)

Re: %age in pivot table

musketeers — Mon, 01 Sep 2014 14:09:52 GMT

Hi,

Actually I need to do these things in pivot table. I am using AGGR function but it is not working also.

Thanks

Re: %age in pivot table

MK_QSL — Mon, 01 Sep 2014 14:15:24 GMT

Check enclosed file....