Discussion Board for collaboration related to QlikView App Development.
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.
try to achieve using intervalmatch()
Try to implement Interval match logic in your case I hope you will get the desired output.
you will have to use intervalmatch in the script
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.