topic Re: Pareto Analysis - Aggr Expression in QlikView

Pareto Analysis - Aggr Expression

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Pareto Analysis - Aggr Expression

sunny_talwar — Fri, 27 May 2016 08:42:17 GMT

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

Re: Pareto Analysis - Aggr Expression

Fri, 27 May 2016 08:44:37 GMT

Re: Pareto Analysis - Aggr Expression

sunny_talwar — Fri, 27 May 2016 08:47:36 GMT

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)

Re: Pareto Analysis - Aggr Expression

syukyo_zhu — Fri, 27 May 2016 08:49:48 GMT

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

Re: Pareto Analysis - Aggr Expression

Kushal_Chawda — Fri, 27 May 2016 08:51:25 GMT

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)

Re: Pareto Analysis - Aggr Expression

sunny_talwar — Fri, 27 May 2016 09:30:10 GMT

Kush I am going to ask the OP the same question

How was my response any different from yours?

Rega Sanyoto

Re: Pareto Analysis - Aggr Expression

Kushal_Chawda — Fri, 27 May 2016 09:48:57 GMT

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

Re: Pareto Analysis - Aggr Expression

Fri, 27 May 2016 10:02:49 GMT

Hello Kushal,

How do i mark his answer correct?

Re: Pareto Analysis - Aggr Expression

Kushal_Chawda — Fri, 27 May 2016 10:05:18 GMT

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

Re: Pareto Analysis - Aggr Expression

Fri, 27 May 2016 10:24:58 GMT

Hi Kushal,

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

Re: Pareto Analysis - Aggr Expression

sunny_talwar — Fri, 27 May 2016 10:26:33 GMT

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

Re: Pareto Analysis - Aggr Expression

Kushal_Chawda — Fri, 27 May 2016 10:41:03 GMT

Ye post me mere post ka bhi screenshot he..

Re: Pareto Analysis - Aggr Expression

sunny_talwar — Fri, 27 May 2016 10:46:07 GMT

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