Pareto Analysis - Aggr Expression

[#1]

Hello all,

In the image below i want to rank category C for < 0.90 but i still have a Garbage after expression.

The current expression is:

=Aggr( If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.10, 'A',

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.75, 'B',)),

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.90, 'C')),

BrandDescription)

Which changes do i have to make?

Thanks regards,

Rega

[#2]

Hi Kushal,

i am not able to mark his answer as correct. Sorry !

[sunny_talwar]

Don't worry Rega Sanyoto‌ it is all good. don't worry about it. For future reference look here:

Qlik Community Tip: Marking Replies as Correct or Helpful‌

This gives all the details regarding marking and unmarking correct and helpful answers.

Best,

Sunny

[Kushal_Chawda]

Ye post me mere post ka bhi screenshot he..

[sunny_talwar]

Sir you and Stefan are the two stars of our Qlik Community. Who else will show up there