Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
recently, I copy an expression from a post and I think there´s a bug.
The expression is:
=Aggr(
If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.8, 'A',
If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.9, 'B',
'C')),
(Product,(=Sum({1} Sales),Desc))
)
The post is: Recipe for a Pareto Analysis – Revisited
When I copy the expression, the structure parameter is no detected in my Qlik (I use Qlik Sense Desktop, february 2018 version)
As it´s showed in the figure, "desc" is not in blue and it does no works.
Do you think it´s a bug or am I doing something wrong?
I believe you problem might be attributed to the negative numbers for Description. The Sum everything is 1,600,549.06 and the value for MAT QUIRURGICOS DE QUIROFANO is 1,376,248.71 which is 85.99%. This is mainly because of the fact that there are -9,458,347.7 from the sum which reduces the positive part down to just 1,600,549.06. What it comes down to is the fact that what are you expecting to see? Do you have an output in mind?