topic Need suggestion to filter the top values based on input value in App Development

Need suggestion to filter the top values based on input value

RK007 — Tue, 28 Jun 2022 09:35:34 GMT

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.

thanks in advance.

brunobertels — Tue, 28 Jun 2022 09:56:53 GMT

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 — Tue, 28 Jun 2022 11:21:28 GMT

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

thanks in advance....