How to pick the value of commision depending on th... - Qlik Community

suvechha_b · ‎2018-04-19

Hi All ,

I have a file which contains

I need to get the correct commission from the above file

Say for eg , I am getting all the three values. But depending on condition "Total Income" - 711230 which lies between Finance amount

start 600001 to finance amont end 900000 . The result of commision should be 6.5 How to achieve the result as currently , I am picking all the three.

Thanks,

ychaitanya · ‎2018-04-19

try to achieve using intervalmatch()

tripatirao · ‎2018-04-19

Hi,

Try to implement Interval match logic in your case I hope you will get the desired output.

Regards

Tripati

sasiparupudi1 · ‎2018-04-19

you will have to use intervalmatch in the script

suvechha_b · ‎2018-04-20

Hi All ,

Please kindly assist me to create the script with the intervalmatch().

I am providing the sample model.

The requirement :

According , to the Total Income of Dealership , the total_percentage should pick.

Say , For eg ,

The dealership : Kempster Ford Pta New

Total Income : 432711

Thus , It should lie between finance_amount_start (0) and finance_amount_end (600000)

and the total_percentage should be 4.75.

How , can I store the total_percentage in variable . As , I need to use the total_percentage for Commision Calculation

depending on the Total Income lies in which level.

0-600000

600000-900000

900000-5000000

How to pick the value of commision depending on the condition ?