Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this as expression: sum(Sales)/sum(TOTAL <Region> Sales). Use your real field names instead of the ones I used in the example.
Try this as expression: sum(Sales)/sum(TOTAL <Region> Sales). Use your real field names instead of the ones I used in the example.