Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate Market Share using the below data in Pivot table in Qlik Sense

TerritoryProductMonthVolume
T_1P1Jan10
T_1P2Jan20
T_1P3Jan30
T_1P4Jan40
T_1P1Feb25
T_1P2Feb35
T_1P3Feb45
T_1P4Feb55
T_1P1Mar15
T_1P2Mar20
T_1P3Mar25
T_1P4Mar35
T_1P1Apr30
T_1P2Apr40
T_1P3Apr50
T_1P4Apr60

 

I am Trying to calculate the Market Share at territory level. The Answer what I am expecting will be in following format. 

TerritoryProductJanFebMarApr
T_1P110%16%16%17%
 P220%22%21%22%
 P330%28%26%28%
 P440%34%37%33%
T_2P110%16%16%17%
 P220%22%21%22%
 P330%28%26%28%
 P440%34%37%33%

 

I tried using multiple functions in the expression in Qlik Sense but I am not getting the correct values. Any help  is appreciated.

Labels (2)
1 Reply
sunny_talwar

Try this

Sum(Volume)/Sum(TOTAL <Territory, Month> Volume)

image.png