Calculating min value in the script

Wed, 09 Dec 2009 16:53:10 GMT

Hello all,

Have no clue what so ever how to solve the following problem:

I have fileds like: Product Family, Product Name, Scenario, Supplier, Purchase Price, Total quantity

Billy, Billy shelf 100*200, 1, Flat, 2, 1000

Billy, Billy shelf 100*200, 1, AGC, 3, 1000

Billy, Billy shelf 100*200, 1, SG, 3.5, 1000

Billy, Billy shelf 100*200, 1, TMG, 1.8, 1000

Detolf, Detolf Table top, 1, Flat, 4, 2500

etc

1. I want to create the minimum bid offer per product and scenario in the script and then create a new field named something like minBid.

2.Then I want to use this to divid each suppliers offer with the minBid to get an Index of their offers.

note: I tried to do that in the chart inside qlikview but that is only valid as long as you haven't selected any suppliers. I did solve the problem by exporting the result to excel and then import it again but I would like to learn how to do it in the script.

Please someone, educate me!

Therese

topic Calculating min value in the script in QlikView

Calculating min value in the script