% Breakup functionality for more than one Dimensions

[diwakarnahata]

Hello All,

Consider the scenario as per the attached image where I want to show % Sales by Product/Region.

I am showing it in a Bar chart with two dimensions - Product Category and Country and one expression - sum(Sales Amount).

I want to see the % breakup of each Country as 100% and then the share of each Product Cat out of that 100% for each Country.

(Currently it breaks the 100% share for all the Countries and then for the Products for each country). The desired functionality is achieved only when one country is selected. But i would like to have this behavior when multiple countries are selected.

Let me know how this can be achieved in QlikView.

Thanks and Regards,

Diwakar

[Gysbert_Wassenaar · Accepted solution]

Try this as expression: sum(Sales)/sum(TOTAL <Region> Sales). Use your real field names instead of the ones I used in the example.