Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

top.PNG

Thank you very much for your help.

Regards.

1 Solution

Accepted Solutions
sunny_talwar

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))))

View solution in original post

3 Replies
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

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
Not applicable
Author

Hi Sunny,

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

top1.PNG

Regards.