Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Minimum function

See attached qvw.


talk is cheap, supply exceeds demand
2 Replies

Re: Minimum function

See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Minimum function

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

Community Browser