Calculation based min and max amounts?

[qlikuser222]

Hi All,

I have a requirement where i need to perform calculations based on Min and Max amount range.

PFA attached Qlik file and also Excel. In Excle what is best way to present data min and max range so it is easy to read by Qlik to perform calculations. For example ID 3 there is no range , but ID 1 has min and max range and i am not sure how to read it in Qlik.

Please help. We can edit data in Excel so it can be read in Qlik to perform calculations

Thanks

[its_anandrjs]

For Id 1 what is mean by <500 or >500 for amount 1100 explain this.

[qlikuser222]

Hi,

If the amount id less the 500 then calculate 1100 * calculation1, else Amount *calculation.

in the data amount is 1100 which is > 500 so we calculate 1100 *  1%