Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pareto Analysis - Aggr Expression

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

1 Solution

Accepted Solutions
Kushal_Chawda

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
)

View solution in original post

13 Replies
sunny_talwar

Can you put that expression as a text in the post?

Not applicable
Author

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





sunny_talwar

Can you try this:


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

syukyo_zhu
Creator III
Creator III

HI,

Try this

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

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

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

Kushal_Chawda

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
)

sunny_talwar

Kush I am going to ask the OP the same question

How was my response any different from yours?

Rega Sanyoto

Kushal_Chawda

regasanyoto‌  As Sunny has responded first with correct answer , you should mark his answer as correct and mine as helpful.

Not applicable
Author

Hello Kushal,

How do i  mark his answer correct?

Kushal_Chawda

First, unmark mine as correct. And then mark his answer as correct