Calculation inside set analysis

[ramp1985]

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!

[MayilVahanan · Accepted solution]

Hi @ramp1985 

Try like below

Sum(Aggr(If(sum({<Year={$(=Max(Year))}>} Revenue)  -  Sum({<Year={$(=Max(Year)-1)}>} Revenue) >=0, 1), Customer))

[ramp1985]

Works - thanks!