how to use set analysis by comparing 2 different measures? (Qlik Sense)

[Anonymous]

Hi,

x and y are 2 measures/numeric dimensions of a data set that I've loaded to Qlik Sense.

instead of using if(x>y,sum(x)) i would like to use set analysis to perform this action:

Sum({$<x={>y}>}x)

but I'm keep getting an error (attached, probably a syntax error).

have any suggestion?

thanks,

Tal

[antoniotiman]

Hi Tal,

Set Analysis is per chart, not per Row

I suggest You use

Sum(If(x>y,x))

Regards,

Antonio

[Anonymous]

did you check this?

Set Analysis Issue - Comparing two Fields

[tresesco]

Try like:

Sum({$<x={"=x>y"}>}x)