Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mariamovasheli
Contributor III
Contributor III

Market Share Difference

Hello, I want to calculate market share difference Within Quarters and can you please tell me How ?

sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>}Volume)

/

sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>} TOTAL Volume)


I need To Write Something like This

1 Reply
Gysbert_Wassenaar

perhaps like this:

(sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>}Volume)

/

sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>} TOTAL Volume))

-

above(

sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>}Volume)

/

sum({< <Owner>, QuarterNum={'$(=max(QuarterNum))'}>} TOTAL Volume)

)


If that doesn't work then please post a small qlik sense app with some example data.


talk is cheap, supply exceeds demand