Sum if in Qlik

[NormanStanleyBadger]

Hi,

In Excel I have the following logic:

IF(Cell Ref>400,400,Cell Ref) - I then sum the total

How can I replicate this in Qliksense? I have the following but it is not working:

If(
Aggr({<Set Analysis>}

Sum({<Set Analysis>}

[Price]),[SKU]) >= 400,

Sum({<Set Analysis>} 400),

Sum({<Set Analysis>}[Price])
)

Thanks

[BrunPierre · Accepted solution]

Hi @NormanStanleyBadger, maybe something just like this.

Sum({<Set Analysis>}
Aggr(If(
Sum({<Set Analysis>} DOB) >= 400,
Sum({<Set Analysis>} 400),
Sum({<Set Analysis>} PRICE)
),[SKU]))

[NormanStanleyBadger]

Spot on. Thank you very much! 😀