if x = y converted to set analysis

[NickHoff]

Currently I have the expression IF(SUM(ALOS=ICUALOS, SUM({$<ExpiredIND = {'0'}>}Cases)).  I know there is a way to put the IF into the set.  How would I go about it? 

[Clever_Anjos]

Is this expression running?

It seems to be invalid to me

[NickHoff]

Sorry, I typed that incorrectly.  The expression runs and is written as:

IF([Total ALOS]=[ICU ALOS], SUM({$<ExpiredIND = {'0'}>}Cases))

I'm looking to get rid of the IF statement and put [Total ALOS] = [ICU ALOS] in the set

[Clever_Anjos]

It´s hard without knowing your data, but

SUM({$<ExpiredIND = {'0'},Total ALOS]=P([ICU ALOS])>}Cases)) should work

[NickHoff]

The data shouldn't matter.  I'm just trying to SUM a field we can call A when only ExpressionX = Expression Y.

Simliar to:

IF ExpressionX = ExpressionY, SUM(A).

Adding the P to the SET doesn't work, because it includes everything possible, not just WHERE X = Y.

[rwunderlich · Accepted solution]

I believe

SUM({$<ExpiredIND = {'0'},[Total ALOS]={"=[ICU ALOS]"}>}Cases))

-Rob

http://masterssummit.com

http://robwunderlich.com

[NickHoff]

Rob,

It worked great, thank you.  It was nice meeting you at the conference, hopefully i'll see you in April at Qlik Masters.