topic help needed on percentage in pivot table in QlikView

help needed on percentage in pivot table

skoppe — Tue, 08 Dec 2009 20:49:27 GMT

Is it possible in a pivot table to calculate percentages? See picture for more information:

I would like to add a column Percentage (%) next to the column Spend (€). For each 'Hoofdsegment' I want percentages for 'Preferred' and 'Non-Preferred'. I made an example in the picture.

Spend (€) is based on a key-figure that is the sum of four set analysis statements.

I hope someone can help, thanks in advance!

help needed on percentage in pivot table

Tue, 08 Dec 2009 20:58:21 GMT

Hi,

see the attached example.

It gives you an idea how it could work.

Good luck!

Rainer

help needed on percentage in pivot table

skoppe — Tue, 08 Dec 2009 21:00:03 GMT

I will look into it, thanks a lot!!!

help needed on percentage in pivot table

Sat, 30 Jan 2010 00:10:24 GMT

If you can help me I would like to know if there is a way to get the percent share based on the Dimensions collaps.

Example

Now if I collapse " br" my shares come up as 100 % instead of broken by "I4I" .I would like to see share broken out by class and I4I with br Collapsed.

Please let me know.

help needed on percentage in pivot table

Sat, 30 Jan 2010 10:05:59 GMT

try Sum(qty)/Sum(total qty) it's the % for each row

help needed on percentage in pivot table

Mon, 01 Feb 2010 18:13:23 GMT

Thanks for your reply,But That will end up giving 100% for each row .I would like to break out by the last dimension I have .So If I move my dimensions Always share should be calculated by the dimesion available at the end.

Thanks