topic Need an example of extended interval match in QlikView

Need an example of extended interval match

Sat, 08 Nov 2014 00:26:34 GMT

Need an example of extended interval match

Re: Need an example of extended interval match

MarcoWedel — Sat, 08 Nov 2014 00:44:54 GMT

links you could find helpful:

IntervalMatch and Slowly Changing Dimensions

Scripting - Intervalmatch

Please Search before Asking a New Question!

http://community.qlik.com/blogs/communitymanager/2010/06/14/improved-search-comes-to-qlikcommunity

hope this helps

regards

Marco

Re: Need an example of extended interval match

MK_QSL — Sat, 08 Nov 2014 00:45:08 GMT

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: Need an example of extended interval match

Mon, 10 Nov 2014 19:21:09 GMT

Thanks for the example!

To explain my scenario, I am modifying below example.

I want the discount to be displayed with respect to each supplier.

Supplier1 | Discount1| Supplier2|Disocunt2|......................

Purchase:

Load * Inline

[

Supplier1,Supplier2, Supplier3,Purchase

ABC, XYZ,EWQ,125

DEF,FRT, YUT,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%

XYZ, 110,130,5%

XYZ, 100,120,5%

FRT,110,140, 2%

FRT,110,112, 2%

EWQ,110,140, 2%

YUT,105,118,6%

];

Wondering how to depict this in current code?

Re: Need an example of extended interval match

MK_QSL — Tue, 11 Nov 2014 07:30:36 GMT

Purchase:

CrossTable(SupplierNo, Supplier,2)

Load RowNo() as ID, Purchase, Supplier1,Supplier2, Supplier3 Inline

[

Supplier1,Supplier2, Supplier3,Purchase

ABC, XYZ,EWQ,125

DEF,FRT, YUT,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%

XYZ, 110,130,5%

XYZ, 100,120,5%

FRT,110,140, 2%

FRT,110,112, 2%

EWQ,110,140, 2%

YUT,105,118,6%

];

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

Join (Purchase) Load * Resident Discount;

Drop Table Discount;

Drop Fields From,To;

Re: Need an example of extended interval match

Fri, 06 Mar 2015 09:06:02 GMT

Hi Manisch, I am new to qlikview.

I have taught myself some fundementals within this area.

But, can u exactly explain the script u posted ?

What does it do , from crosstable function to the intervalmatch function.

Thanks!