Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bi_analysts_2
Not applicable

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

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

3 Replies
antoniotiman
Not applicable

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

Hi Tal,

Set Analysis is per chart, not per Row

I suggest You use

Sum(If(x>y,x))

Regards,

Antonio

Highlighted
balrajahlawat
Not applicable

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

tresesco
Not applicable

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

Try like:

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