Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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
Partner - Champion III
Partner - Champion III

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