Test Column(X) with a range values into IF statment

[Riccardo]

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

[sunny_talwar]

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