Discussion board where members can get started with QlikView.
Is it possible to identify the highest values within a column that (together) make up a certain percentage (e.g. 20%)
of the column's sum? Like a pareto analysis but in a straight table? I also don't want to sort the values, just assign
a value like "1" or "yes/no" to them.
Please find the example attached.
Thank you in advance.
You might only be able to do it using this
Recipe for a Pareto Analysis – Revisited
But this is only available in QV12 and above...
View solution in original post
1) Do you have QV 12.1 or above?
2) Can you share the desired output for the sample provided?
I am using QlikView 11. The output should be like this:
The first column is the sorted.
I hope it makes sense.
Hmm, that's unfortunate. I think it's quite a useful feature.
Well thank you for your time and effort.