Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I'm new to QlikSense, and tried to find an answer for this in the community, but didn't.
What i'm trying to, is to make a measure that will count the distinct numbers of a Dimension, if a certain calculation is above zero 0,-. = How many unique customers revenue is larger this year than last year?.
So, something like (This dosn't work):
Count(distinct{<sum({<Year={$(=Max(Year))}>} Revenue) - Sum({<Year={$(=Max(Year)-1)}>} Revenue) ={>"0"}>} Customer)
Looking forward to hear from you!
Hi @ramp1985
Try like below
Sum(Aggr(If(sum({<Year={$(=Max(Year))}>} Revenue) - Sum({<Year={$(=Max(Year)-1)}>} Revenue) >=0, 1), Customer))
Hi @ramp1985
Try like below
Sum(Aggr(If(sum({<Year={$(=Max(Year))}>} Revenue) - Sum({<Year={$(=Max(Year)-1)}>} Revenue) >=0, 1), Customer))
Works - thanks!