Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to limit top N when using 4 expressions and 1 dimension. ?

Hello comunity,

I have this straight table where I have 1 dimension (dm_emisor.identificador_bloomberg) and 4 expressions. I need to limit the top 20 order by "Total", I tried with RANK() and dimension limit and it is not working. kq75rq.

2 Replies
andrey_krylov
Specialist
Specialist

Hi, Alejandro. Try to limit in Chart Properties, but you need then to make Total the first expression

And Rank() function in calculated dimension should be working

=Aggr(

       If(Rank(

            Aggr(

                YourExpression)

            , [Dimension])

            , 1, 0) <= 20 ,

      [Dimension] )

, [Dimension] )

Sergey_Shuklin
Specialist
Specialist

Hello, Alejandro!

PFA.

There are two ways how to achieve your request:

1. Using Rank() function (for keeping dimensions clean);

2. Using calculated dimension with hidden null-fields.