How to add multiple field values in a button as a filter in Qliksense

[sharu055]

Hi,

I have a field name Fruit and values are Apple, Orange, Banana, Mango, Grape.

I need to create a button with the field values as a filter in qliksense. Button should pick only Apple, Orange, Mango from the field fruit. How to do this setup in Qliksense button.

I tried ='("*Apple*"|"*Orange*"|"*Mango*")' , ='("Apple"|"Orange"|"Mango")', ='Apple|Orange|Mango' as a field value but not achieve.

Please help 

[MatheusC]

Enter your values ​​as below:

='Apple;Orange;Mango'

separator ;

[Amit_Prajapati · Accepted solution]

Hi @sharu055 , Create a button and on action select values in fiels option and give the input with semi-comms (;) seprated as @MatheusC  mentioned.

[sharu055]

@Amit_Prajapati Thank you so much, it works. I need one more help, When i select this button the button color should turn Green color and other button should be in Bule color. like below screen shot of qlikview dashboard. How to achieve in Qliksense please help with procedure 

[Amit_Prajapati]

Hi @sharu055 ,

To dynamically change the button color based on selection:

• Create a variable (e.g., vActive) to track the selection state.

• Set the variable in the button's action using: Set variable value → vActive = 1 (or 0 depending on the logic).

• Use a conditional expression to evaluate the variable: If(vActive = 0, 1, 0) — this toggles the value between 0 and 1.

• Apply conditional styling in the button's background color property: If(vActive = 1, Green(), Red()) — this sets the color based on the variable's value.

[sharu055]

Hi @Amit_Prajapati 

I created the Variable vActive and given value as 1, and in button i added set variable value =If(vActive = 0, 1, 0) and in background color of button chart i added f(vActive = 1, Green(), Red()). but its not working as expected added the screenshot below. Please help how to add with screenshot, it will be very helpfull

[Amit_Prajapati · Accepted solution]

Hi @sharu055  ,

To dynamically change the button color based on the selected chart, use the following expression:

You can modify the v_changeTable variable using the Set Variable Value action, assigning it values like 'Piechart01' or 'Piechart02' to control which color is applied.

=if(v_changeTable = 'Piechart01', '#ce7f19', '#C4A484')

Let me know if you need more details.

[sharu055]

@Amit_Prajapati Thanks, It works.