Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Calculate Market Share in Pivot on Sub Dimensions?

Hi,

I have a Pivot as follows

France         

     Prod A    

     Prod B    

UK

     Prod A

     Prod C

     Prod E

Italy

     Prod A

     Prod E

I want to see each Prod Market share vs total Country but do not really get the generic formula to work.

e.g. Can I referer to the Country Dimension dynamically in the calculation e.g. Value/Total Country=P Data or something

Thanks

A

1 Reply

Re: Calculate Market Share in Pivot on Sub Dimensions?

Try something like this: Sum(Value)/Sum(Total <Country> Value)


talk is cheap, supply exceeds demand
Community Browser