Count values ordered by expression (Aggr, above, sum)

[Anonymous]

Hi guys,

I have a problem when I comes to count the top products of my pareto, which in the example shown in the image would be 10, which I want to show in a text object.

Thank you very much for your help.

Regards.

[sunny_talwar]

Which version of QlikView do you have? If you have QV12.1 or above, this can be done

Recipe for a Pareto Analysis – Revisited

If not, then I am afraid, it will be very difficult to do this

[sunny_talwar · Accepted solution]

An expression like this

=Count(DISTINCT Aggr(If(RangeSum(Above(Sum(Ventas),1,RowNo())) / Sum(total Ventas) <= 0.8, CodProd), (CodProd, (=Sum({<CodProd>} Ventas), Desc))))

[Anonymous]

Hi Sunny,

I used this expression but nothing, the value he throws at me is not right

Regards.