Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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