Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

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

Hi All ,

I have a file which contains

Capture.PNG

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.

Capture.PNG

Thanks,

4 Replies
ychaitanya
Creator III
Creator III

try to achieve using intervalmatch()

tripatirao
Creator II
Creator II

Hi,

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

IntervalMatch

Regards

Tripati

sasiparupudi1
Master III
Master III

suvechha_b
Creator III
Creator III
Author

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

Capture.PNG