How to create intervalmatch

jim_chan — Sun, 18 Sep 2016 21:30:52 GMT

Hi guys,

I need to create a intervalmatch for employee Yearly Sales Target.

So i have created Inline Data

Interval_Sales_Target_Percentage_Grade:

load * inline

[

Year,Min_Sales ,Max_Sales,Grade

2015,85.01,95, Average

2015,95.01,100,Good

2015,100.01,999.9,Excellent

];

and

IntervalMatch:

IntervalMatch (Sales)

Load distinct Min_Sales, Max_Sales

Interval_Sales_Target_Percentage_Grade;

Problem is... i think the intervalmatch should not be "Sales". My orders and sales_target table is 2 diff table. But i think i need to create an expression, such as (total_sales/target)*100 as percentage_achieved. Then in my intervalmatch table, i should interval match(percentage_achieved).

both tables rite now are linked with orders_key.

Rgds

Jim

Re: How to create intervalmatch

swuehl — Sun, 18 Sep 2016 21:36:35 GMT

You could use a mapping table approach (using MAPPING LOAD prefix and ApplyMap() ) or a JOIN to create a single table with Total_Sales and Target values. Then do a resident LOAD to create your percentage column and use IntervalMatch() to match against your grades (maybe using year as key field in the IntervalMatch() extended syntax?).

topic How to create intervalmatch in QlikView

How to create intervalmatch

Re: How to create intervalmatch