Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Minimum function

Hi all

I am trying hard to figure out a way for this. Kindly help.

I have the following table after doing some work on the base data.

PlaceWarehouseSourceFreight1Freight2Sum (Freight1, Freight2)
P1WH1S110010110
P1WH1S220020220
P1WH2S120010210
P2WH2S130020320
P2WH2S240010410

I want to add one column "Classification", which would give

     "L1" if the Sum column for a given Place is the MINIMUM among the available options.

     "L2" if the Sum column for a given Place is the 2nd MINIMUM and so on.

I have showed the example for 2 Places.

Something like this.

PlaceWarehouseSourceFreight1Freight2Sum (Freight1, Freight2)Classification
P1WH1S110010110L1
P1WH1S220020220L3
P1WH2S120010210L2
P2WH2S130020320L1
P2WH2S240010410L2

Thanks in advance.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks a lot Gysbert.

Just wanted to check if there is any way this could be done in the script.

Would be very helpful if a separate listbox could be made.

Thanks again