topic Re: Count values ordered by expression (Aggr, above, sum) in QlikView

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

Anonymous — Fri, 03 Nov 2017 17:54:42 GMT

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.

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

sunny_talwar — Fri, 03 Nov 2017 18:03:26 GMT

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

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

sunny_talwar — Fri, 03 Nov 2017 18:08:31 GMT

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

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

Anonymous — Fri, 03 Nov 2017 18:14:04 GMT

Hi Sunny,

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

Regards.