I'm quite new to QlikView and I'm facing currently following problem - there is a list of car dealers, for each of them I calculate let's say 3 KPIs, like "% of total sales", "% of bad loans", "% of fraud cases".
Next step is to calculate deviation of each KPI from the average value for all the dealers. If the deviation is greater than 20%, KPI gets note=4, if > 15% then gets note=3, if > 10% than note=2 else note=1. So before final calculation I have following variables:
if dealer_grading > 3.2 then dealer_grading_note = 4; else if dealer_grading > 2.6 then dealer_grading_note = 3; else if dealer_grading > 1.45 then dealer_grading_note = 2; else dealer_grading_note = 1;
How you would implement it in QlikView? I mean the last step, calculation of dealer_grading_note / dealer_grading. At the end, it should be shown in the textbox I was trying to write own function, but I have still too less experience .