Qlikview load (intermediate values) - Qlik Community

Report Inappropriate Content · ‎2012-04-02

Hallo,

I hope sombody can help me with my problem.

I have some Provider-tables, which don't have the same gradation (weight).

Example:

DHL:

Provider weight until(kg) price

DHL 0,5 3,25

DHL 1 4,25

DHL 1,5 6,3

DHL 2 10,20

Etc. in 0,5 steps

Fedex:

Provider weight until(kg) price

FEDEX 1 4,25

FEDEX 2 7,25

FEDEX 3 9,3

FEDEX 4 15,20

Etc in 1kg steps

TNT:

Provider weight until (kg) price

TNT 2 4,25

TNT 4 7,25

TNT 6 9,3

TNT 8 15,20

in 2kg steps

If I search now for a weight of 0,5kg, in the tables, it will only be found in the DHL-Table. In the Fedex Table the value that should be found is (upto) 1kg.

While reading FEDEX the following table should be loaded:

Provider weight until price

FEDEX 0.5 4,25

FEDEX 1 4,25

FEDEX 1,5 4,25

FEDEX 2 7,25

FEDEX 2,5 7,25

FEDEX 3 9,3

FEDEX 3,5 9,3

FEDEX 4 15,20

FEDEX 4,5 15,20

While reading TNT the following table should be loaded:

Provider weight until price

TNT 0,5 4,25

TNT 1 4,25

TNT 1,5 4,25

TNT 2 4,25

TNT 2,5 7,25

TNT 3 7,25

TNT 3,5 7,25

TNT 4 7,25

TNT 4,5 9,3

TNT 5 9,3

TNT 5,5 9,3

TNT 6 9,3

Would be very nice if somebody can help me .

Thanks in advance

Marcus

Jason_Michaelides · ‎2012-04-02

Look into using IntervalMatch(). F1 help is pretty good or there are good examples of use in this forum.

Hope this helps,

Jason

Clever_Anjos · ‎2012-04-02

Maybe you should use IntervalMatch.
Another aproach could be generate a temp table like below

Weight:

LOAD

RowNo() / 2 as weight

AutoGenerate 20;

Then use this table "left joined" with your ProviderTable