Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariamovasheli
New 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

Re: Market Share Difference

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
Community Browser