# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Contributor

## Max() with % of Sum?

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.

Mats

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Max() with % of Sum?

You might only be able to do it using this

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

4 Replies
Highlighted
MVP

## Re: Max() with % of Sum?

1) Do you have QV 12.1 or above?

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

Highlighted
Contributor

## Re: Max() with % of Sum?

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.

Highlighted
MVP

## Re: Max() with % of Sum?

You might only be able to do it using this

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

Highlighted
Contributor

## Re: Max() with % of Sum?

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

Well thank you for your time and effort.

Best regards

Mats