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.
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))
Retrieving data ...