Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Qlikview load (intermediate values)

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

2 Replies
jason_michaelid
Honored Contributor II

Qlikview load (intermediate values)

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

Hope this helps,

Jason

Employee
Employee

Qlikview load (intermediate values)

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

Community Browser