Display Fields in dropdown

[pala_jagadeesh]

I Have Three  fields  Item1,Item2,Item3

Each filed has 20 records

Is it possible to put three fields in Dropdown list like below

when I clik on item1 ,the records belongs to item1 will change for other charts

listbox

Item1

Item2

Item3

when I clik on item2 ,the records belongs to item2 will change for other charts

when I clik on item3 ,the records belongs to item3 will change for other charts

[Andrei_Cusnir]

Hello,

I am not 100% sure that I understood the exact use case scenario. However, based on what you have described you can use Set Analysis in combination of charts and Variable input. Here is an example:

1. Load the data 

2. Create a variable:

3. Create an Variable input object:

• Appearance > Variable > Name: vSelectedItem
• Appearance > Variable > Show as: Drop down
• Appearance > Values> Fixed or dynamic: Dynamic
• Appearance > Values> Dynamic values: =Concat(DISTINCT listbox, '|') // To create a list of values from the loaded dataset

4. Create a chart that you want to be affected by the selection (e.g. Bar chart😞

• Data > Dimensions > Bars: listbox
• Data > Measures > Expression: =Sum({<listbox={'$(vSelectedItem)'}>}Values) // Will be affected based on the selection in the variable

5. Outcome is:

As you can see, based on the selection of the Variable input, we can see different sum values. You can modify the use case scenario based on your needs.

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
  

[pala_jagadeesh]

@Andrei_Cusnir ,

Thank you for your quick answer,

Here  i have created Item1, item2, item3  are three buttons

I want these three buttons come like(appeared as) dropdown  like below

when i clik on items filter these three buttons come like this

 is this possible.

[Andrei_Cusnir · Accepted solution]

Hello @pala_jaga,

My assumption is that you have assigned some actions on those buttons and you would like to have this menu displayed as dropdown list, so when you pickup an item, it will execute those actions. 

Have a dropdown list with buttons is not available at the moment, so you can submit a feature request [1] and elaborate in detail as to how this is going to be beneficial for you and other users. 

One workaround that might get you as close to your use case scenario as possible, is the use of container and Variable input object. For example you can do the following:

1. Create a new container and add there buttons:

2. Then you can add the "Show condition" for each object:

• ='$(vSelectedItem)'='Item1'
• ='$(vSelectedItem)'='Item2'
• ='$(vSelectedItem)'='Item3'

3. Edit the container and go to Appearance > Container > Tabs and switch it off

4. Now whenever you choose an item from the drop down list, only the corresponding button will be available for clicking

I hope that this information is helpful! 

---

[1] https://community.qlik.com/t5/Knowledge-Base/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1...