Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.