topic Re: InvervalMatch in QlikView

InvervalMatch

MK_QSL — Tue, 06 May 2014 15:30:57 GMT

What am I doing wrong in below?

=======================================

Purchase:

Load * Inline

[

Supplier, Purchase

ABC, 125

DEF, 115

];

Discount:

Load * Inline

[

Supplier, From, To, Discount

ABC, 100, 119, 2%

ABC, 120, 129, 3%

ABC, 130, 150, 4%

DEF, 110, 119, 4%

DEF, 120, 129, 6%

DEF, 130, 150, 8%

];

INNER JOIN IntervalMatch (Purchase,Supplier) Load From, To, Supplier Resident Discount;

Join (Purchase) Load * Resident Discount;

Drop Table Discount;

Drop Fields From,To;

===========================================

Re: InvervalMatch

Gysbert_Wassenaar — Tue, 06 May 2014 15:41:48 GMT

No idea. The resulting table contains exactly the data I would expect. Can you explain what you think is wrong?

Re: InvervalMatch

Tue, 06 May 2014 15:43:44 GMT

Seems to work fine. Whats the issue at hand?

Re: InvervalMatch

MK_QSL — Tue, 06 May 2014 15:46:18 GMT

Purchase Table is the Actual Purchase for this Year

Discount Table is showing Discount % at variable range.

I need to find out currently where we are based on Current Purchase.

i.e.

Supplier, Purchase, %Discount

ABC, 125, 3%

DEF, 115, 4%

Re: Re: InvervalMatch

Gysbert_Wassenaar — Tue, 06 May 2014 15:53:31 GMT

That's the result I see here using your script. See attached qvw.

Re: InvervalMatch

MK_QSL — Tue, 06 May 2014 15:58:49 GMT

Don't know why it was not giving me desired result previously !!!

Thanks...