Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Drop down box or anything similar for top5 top10

Hi stalwar1‌, jmc

I have to create a filter which can show data top 10 top 5 top 20 on the basis of count(id) measure.

like a drop downbox or  buttons

.

Regards,

Vinayak

1 Solution

Accepted Solutions
passionate
Valued Contributor

Re: Drop down box or anything similar for top5 top10

Hi Vinayak,

You can follow the below steps:

First.pngSecond.pngThird.pngFourth.png

Regards,

Pankaj

16 Replies
arvind_patil
Valued Contributor III

Re: Drop down box or anything similar for top5 top10

HI Vinayak,

May be attached app will give you basic Idea.

Thanks,

Arvind Patil

Not applicable

Re: Drop down box or anything similar for top5 top10

Hi Arvind

Sir I am using free qlik sense desktop I am unable to see any sheet in the app.

Regards,
Vinayak

passionate
Valued Contributor

Re: Drop down box or anything similar for top5 top10

Hi Vinayak,

PFA Solution.

For Top N using listbox/Multibox.

Regards,

Pankaj

passionate
Valued Contributor

Re: Drop down box or anything similar for top5 top10

Hi Vinayak,

You can follow the below steps:

First.pngSecond.pngThird.pngFourth.png

Regards,

Pankaj

Not applicable

Re: Drop down box or anything similar for top5 top10

Hi Pankaj

Sir thanks alot for your detailed explaination.
I am novice in qliksense and used alot of calculated field in data model viewer I dont want to tamper with data load editor as I am not expert enough.
Also I am trying to apply it on pivot table.
top 5 top10 based on count(iD)

Attaching my app and data

Thanks a lot

Regards,
Vinayak

Not applicable

Re: Drop down box or anything similar for top5 top10

Hi Pankaj,

Thanks a lot for the solution.
But I am facing an issue whenever I am not selecting any value from Limit box all the countries are coming under one row named'other'.
what am I doing wrong.


Thanks,

Vinayak

Not applicable

Re: Drop down box or anything similar for top5 top10

HI Pankaj,

Thanks for the solution but if you could guide me into changing the names of the filter option from 5 to 'top 5' so that when I select top 5 it shows the same also is there a way I can preselect the filter to all the cities.

Regards,
Vinayak

passionate
Valued Contributor

Re: Drop down box or anything similar for top5 top10

HI Vinayak,

You only need to change the inline table from:

Lim:

Load * Inline[

Limit

5

10

20

];

---------------------------------

Lim:

Load * Inline[

Limit

Top 5

Top 10

Top 20

];

Regards,

Pankaj

Not applicable

Re: Drop down box or anything similar for top5 top10

HI Pankaj,

I have tried this but when I dont select any of the options it shows only the first row is there a way to show all the cities when there is no selection.

thanks alot for  taking out time for this discussion


Regards,

Vinayak

Community Browser