Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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.
Thanks in advance.
Go to Solution.
See attached qvw.
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.