How to create drop down menu for filter pane

[lweny]

Hi all, I'm very new to Qlik Sense and still didn't get how to use this software. I'd like to ask a question, which would be a very basic question for you the experts: How to make a filter pane become a drop-down-single-selection filter pane? The current visualization and the expected result are attached. Thanks.

[Anil_Babu_Samineni]

For one issue, You have created three threads. Don't duplicate for one issue

Duplicate1 Duplicate2

[Anil_Babu_Samineni]

Coming to your question - There is no option as default where as you can use extension for that.

[lweny]

Hi, apologize, I think it's because the internet.. since I often failed in accessing this web so I refreshed it often. And thanks for your answer, so what kind of extension I could use to accomplish this goal?

[Anil_Babu_Samineni]

#Vizlib Filter is the one. To download, use this link https://www.vizlib.com/#library

[jonathandienst · Accepted solution]

No need for an extension. Just create a filter pane 1 tile high. This will display the field name. Click on the field name to popup the list.

[lweny]

Hi Jonty, thanks for replying! Sorry I'm not able to open your capture.png.. internet problem, I didn't even understand why the internet is so lame.. Could you please explain more detailed? I've tried but didn't work.

[lweny]

One additional question, If I have a field named A which has value A1 and A2. Then I'd like to sum the total sales for A2 only. I have created an IF calculation =if([A]='A2', Sum([Total_sales)])) under the Data --> Expression but the result was dash (-). Could you please point out the mistakes I've made? Thanks in advance!

[jonathandienst]

As a general rule, i suggest that you start a new thread for a new question, but here goes:

=Sum(If(A = 'A2', [Total_sales]))

or (better)

=Sum({<A = {'A2'}>} [Total_sales])

[lweny]

Hi Jonty, Yes, I've created a new thread for this question and got the solution already, however, many thanks for your reply! Oh, and by the way, I'm wondering if you can help me out with another problem on this link: https://community.qlik.com/t5/New-to-Qlik-Sense/Bar-chart-combo-chart-formatting/m-p/1575931#M134463, since I'm very new to Qlik Sense.. Thank you so much!