Top N

[urbanfaces]

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

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(Sales), 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(Sales), Function, Name)<=10

”}

>}

Sales)

[theoat]

Peux-tu mettre un exemple de ce que tu souhaites, je ne suis pas sur d'avoir compris.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.