Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need an example of extended interval match
links you could find helpful:
IntervalMatch and Slowly Changing Dimensions
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
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;
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, 110,130,5%
XYZ, 100,120,5%
FRT,110,140, 2%
FRT,110,112, 2%
EWQ,110,140, 2%
EWQ,110,140, 2%
EWQ,110,140, 2%
YUT,105,118,6%
];
Wondering how to depict this in current code?
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, 110,130,5%
XYZ, 100,120,5%
FRT,110,140, 2%
FRT,110,112, 2%
EWQ,110,140, 2%
EWQ,110,140, 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;
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!