topic Re: Sales Rep Incentive - unrelated tables in QlikView

Sales Rep Incentive - unrelated tables

johngouws — Tue, 30 Apr 2019 05:16:38 GMT

Good morning.

I need create a chart to show a Sales Rep's Incentive % based on Target Achieved %. This expression needs to be in the chart and not in the Load script.

Looking at the snippet you see the 2 tables that are not related.

REP 01 achieved 90% of Target, therefore I need to look at the Achieved_% field in the lookup table and display the Lookup value. In this case I should display 10%. In the attached App I have attempted a couple of expressions, but after meany hours, I need to escalate the request.

Thank you in advance.

Re: Sales Rep Incentive - unrelated tables

arpitkharkia — Tue, 30 Apr 2019 05:29:28 GMT

You can do a simple association or a left join if you dont need all records from the lookup table.

I hope this is what you need.

PFA

Re: Sales Rep Incentive - unrelated tables

johngouws — Tue, 30 Apr 2019 05:42:12 GMT

Thank you for the reply.

That would be so simple. Unfortunately that will not work because there are other factors that take place in the UI.

Re: Sales Rep Incentive - unrelated tables

arpitkharkia — Tue, 30 Apr 2019 05:52:40 GMT

Hey,

I used Lookup() now. PFA.

I hope this makes sense.

Re: Sales Rep Incentive - unrelated tables

johngouws — Tue, 30 Apr 2019 06:40:20 GMT

Hi. Thanks so much for still trying. Lookup() cannot be used in a expression in a chart.

Maybe by creating the Achieved % in the script I caused confusion. In the real world, the user can adjust a variable which impacts on the Achieved %. I have removed the Achieved % from the script and applied more logic to the "Lookup REP incentive" object. Looking at the expression you will see why I cannot do anything in the script.

Re: Sales Rep Incentive - unrelated tables

arpitkharkia — Tue, 30 Apr 2019 08:39:56 GMT

Im not sure then, what i can think of now is to use if() function like

if(Ach%='100%',15%) and so on

But this may not e the best solution.

Re: Sales Rep Incentive - unrelated tables

johngouws — Tue, 30 Apr 2019 09:25:42 GMT

I also initially thought of something like that, but as you say, its not the best.

Thanks for looking at it though..