
Creator
2023-03-23
07:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
483 Views
1 Solution
Accepted Solutions

Partner - Master
2023-03-23
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]))
2 Replies

Partner - Master
2023-03-23
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]))

Creator
2023-03-24
05:22 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Spot on. Thank you very much! 😀
423 Views
