topic Max() with % of Sum? in QlikView

Max() with % of Sum?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear community,

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.

Mats

sunny_talwar — Tue, 30 May 2017 14:53:26 GMT

1) Do you have QV 12.1 or above?

2) Can you share the desired output for the sample provided?

Anonymous — Tue, 30 May 2017 15:02:53 GMT

Hi Sunny,

I am using QlikView 11. The output should be like this:

The first column is the sorted.

I hope it makes sense.

Thanks.

sunny_talwar — Tue, 30 May 2017 15:29:38 GMT

You might only be able to do it using this

But this is only available in QV12 and above...

Anonymous — Tue, 30 May 2017 15:37:32 GMT

Hmm, that's unfortunate. I think it's quite a useful feature.

Well thank you for your time and effort.

Best regards

Mats