Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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....