Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi.
i have come to a halt.
i have a scenario whereby i have three discounts ifs.
1. You can leave a discount on order row and also on the header
2. you can leave a discount on the order row and ignore the header
3. you can leave an order row empty and choose to use the header discount.
the header discount is given always and there is a flag on the row level steering if it is to be included in the discount.
i have created the exact example attached to this message, and am wondering how to fix this solution, is it front end or back end and if backend how to steer my if statements into a global flag.
Best regards,
Bradley
It's because you don't have any aggregation function in your expression. You need to write
Sum([Amt Sold] * Price)
instead of
[Amt Sold] * Price .
See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations
HIC