AGGR Forumla

[urbanfaces]

I have this Ranking formula that returns—(Dash) when a Top N criteria is unmet. I would like it to leave the cell blank instead of Dash. Please note that the—before AGGR does not solve for it. I just want anything outside of the TOP to be a blank cell.

=AGGR(IF(RANK(- AGGR(RANK(COUNT(VALUE))/COUNT(NAME),FUNCTION, NAME))<=10,COUNT(VALUE))FUNCTION,NAME)

Any help will be greatly appreciated.

[theoat · Accepted solution]

Hello,

You can try it :

ALT(AGGR(IF(RANK(- AGGR(RANK(COUNT(VALUE))/COUNT(NAME),FUNCTION, NAME))<=10,COUNT(VALUE))FUNCTION,NAME),' ')

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[urbanfaces]

WOW, you are STAR. What about this question I had posted but I still did not get the right answer.

I have been following the Top N the example on YouTube, but I guess I lost.

Here is the link https://www.youtube.com/watch?v=_abyc3JJxsM

While the example only looks at Brand and Sales

In my example. I group Function, Name on Sales

When I do the of

Rank(Sum(Value), Function, Name)<=10

It tested for -1 and 0. -1 means the Sales falls within the Top 10

However, when I try to bring the actual result so I can use variable input, it does not work.

This is what I am using to try to filter the column for only the Top 10

Sum(

{<

Function, Name={“= Rank(Sum(Value), Function, Name)<=10

”}

>}

Value)

[theoat]

Can you give me the link of oyur original post ?

[urbanfaces]

Thank you very much. Here is the original link

https://community.qlik.com/t5/New-to-Qlik-Analytics/Top-N/m-p/2432139#M248655