BUTTONS PLAY

[Krish2459_58]

Hi,

I have data like below image as Inline load.

In the frond end I have created two buttons(Button A and Button B) to categorize the column values as per the requirement.

Let's say when user click on both the buttons the filter (Category)should also select both values.

Could you please help me.

Thanks..

[Krish2459_58]

Hi,

Is there any approach to get this.

Thnaks...

[snibrahim1993]

Hi @Krish2459_58 

Please try like below

Create a variable in the Qlik Sense script to store the selected values from the buttons. Let's name it "SelectedValues":

SET vSelectedValues = '';


Assign an action to each button to update the variable "SelectedValues" based on the user's selection. Go to the properties of each button and add the following action:

For Button1:

• Action type: Set Variable
• Variable: vSelectedValues
• Value: If(IsNull(vSelectedValues), 'A,B,C', vSelectedValues & ',A,B,C')

For Button2:

• Action type: Set Variable
• Variable: vSelectedValues
• Value: If(IsNull(vSelectedValues), 'D,E,F,G', vSelectedValues & ',D,E,F,G')

These actions update the variable "SelectedValues" by appending the selected values to the existing values if the variable is not null, or initialize it with the selected values if it is null.

5. Create a filter pane object in the Qlik Sense sheet to display the Category field. Set the filter pane to use the variable "vSelectedValues" as its field. This will dynamically apply the selected values from the buttons as the filter.

[Krish2459_58]

Hi @snibrahim1993 

Thanks for your response.

FolIowed the steps but it's not working like when I click on the button.Nothing happens.Here is the logic.

SET vSelectedValues = '';

=If(IsNull(vSelectedValues), 'Property,Property Street,Suburb,City,Region,District,Property Co-ordinates,Property Manager,Property Type,Property Status,Property Sqm’,

vSelectedValues & 'Property,Property Street,Suburb,City,Region,District,Property Co-ordinates,Property Manager,Property Type,Property Status,Property Sqm ')

Thanks..

[Krish2459_58]

Hi,

Any suggestions please.

Thanks..

[snibrahim1993]

@Krish2459_58 Can you please share the expected result. So I can help you on that

[Lokesh_5045]

@Krish2459_58 

Step1: Create button and add action - Select values matching search criteria
Step2: In value, write expression like this - '(a|b|c)'

Step3: Create another button for other selections - d, e, f, g in same manner.

Above picture: Button 1

Above picture: Button 2

[Krish2459_58]

Hi @Lokesh_5045 

When we select two buttons the should append in sted of override.

Like in the avove case if two buttons were selected the category filter should have selected both button vales(a,b,c,d,e,f,g)

Thanks..

[Lokesh_5045]

@Krish2459_58 Try button action - Toggle field selection

keeping the values as like above.