Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
RK007
Contributor II
Contributor II

Need suggestion to filter the top values based on input value

Hi,

 

I do have a requirement to filter the Top values based on the value that user enters into Input box in Qlik Sense.

But, its not filtering the exact values as per Input.

For ex: 

I have entered 5, it should give only top 5 values, but its not giving that, it also including the other duplicate values.

I have 2 dimension and 1 measure.

i added the screenshot of it for reference.

 

Ramakoti01_0-1656408888065.png

 

thanks in advance.

Labels (1)
2 Replies
brunobertels
Master
Master

Hi 

create a calculated dimension for Providers with aggr and rank function  like that 

 

=aggr(if(rank(Claims))<=$(vTop),Providers ),Providers )

where vTop is the name of the variable input button 

 

RK007
Contributor II
Contributor II
Author

Thank you so much.. Its working for me

need one more suggestion..

Its giving the only sum of top 5 values, is there any way to show the total value of the provider irrespective of the Input number?

added the both the screenshots for the reference

Ramakoti01_0-1656415169579.png

 

Ramakoti01_1-1656415196916.png

 

thanks in advance....