2 Replies Latest reply: Apr 2, 2012 8:06 AM by Clever Anjos RSS

    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