Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
NormanStanleyBadger

Sum if in Qlik

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

Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master

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]))

View solution in original post

2 Replies
BrunPierre
Partner - Master

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
Author

Spot on. Thank you very much! 😀