Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Tal,
Set Analysis is per chart, not per Row
I suggest You use
Sum(If(x>y,x))
Regards,
Antonio
did you check this?
Try like:
Sum({$<x={"=x>y"}>}x)