topic Re: Aggr in Set analysis in App Development

Aggr in Set analysis

chewbacca23 — Thu, 07 Mar 2019 08:50:50 GMT

Hi all,

I'm tryind to display , for the #2 Product (based of sum of defect) , the name of the defect.

In a chart , I put "Name of defect" as dimenion and this code as Measure

sum({<ID={'=aggr(if(rank(sum(Count_DEFECT))=1,ID),ID)'}>}Count_DEFECT)

but seem not working.

When I use this code

sum({<ID={'CODE'}>}Count_DEFECT)

It's work.

Can anybody help me?

Thank you..

y_grynechko — Thu, 07 Mar 2019 09:15:06 GMT

Good Morning,

the way I loaded data:

Logic:

I hope I understood correctly what you want to accomplish.

Zhandos_Shotan — Thu, 07 Mar 2019 10:14:34 GMT

Hi
Im wondering how this expression
sum({<ID={'=aggr(if(rank(sum(Count_DEFECT))=1,ID),ID)'}>}Count_DEFECT)
and sum({<ID={'CODE'}>}Count_DEFECT)

will work differently. Both expressions search exact string values bcos placed in single quotes.

Single quotes is for exact text values, double quotes "" for search expressions. Also in some cases we need to use $(=Expression).

Test aggr(if(rank(sum(Count_DEFECT))=1,ID),ID) in separate measure and

Try: sum({<ID={"=aggr(if(rank(sum(Count_DEFECT))=1,ID),ID)"}>}Count_DEFECT)

OR sum({<ID={'$(=aggr(if(rank(sum(Count_DEFECT))=1,ID),ID))'}>}Count_DEFECT)

Hope it helps

chewbacca23 — Thu, 07 Mar 2019 10:41:24 GMT

Thank you for the replys .

This solution works :

sum({<ID={'$(=aggr(if(rank(sum(Count_DEFECT))=1,ID),ID))'}>}Count_DEFECT)

As IRL, I need $

thanks a lot