Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've an issue about matching a calculated formula into a range values defined inside another table.
Please see my Testcase Qlik App.
RANK column should be works fine...
Can you help me?
Thank you very much, best regards.
Riccardo
Try this:
Sum(Aggr(If(RAN_TYPE = 'COST' and Sum(Num)/100 >= RAN_FROM and Sum(Num)/100 <= RAN_TO, Sum(RAN_VALUE)), RAN_FROM, RAN_TO))