Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Federicofkt
Contributor III
Contributor III

Apply filter with button in analysis

Hi,

 

I need to create a button that filters out a specific product from all the measures.

like: measure for items sold = 100, I'd like that button to behave like a filter in the measure (e.g.: Type -= {'Car'}).

 

I've set a button with the "select value from field action", then set the field and then put the value in:
Type <> {'Car'} but it's not working.

 

What I need is the button to behave like I have the filter box, I select "car" and then I select the excluded ones.

 

Thanks!

Labels (3)
2 Replies
Padma123
Creator
Creator

Hi,

Exclude values in one field then do it load script

like if(Type='Car',1,0)as new_field;

after In button select value in field(select new_field ,value=0)

Bhushan_Mahajan
Creator II
Creator II

@Federicofkt Follow below process.

1. Create one variable with value as 1

2. Take a button chart create two Actions with name Car and Others as below.

Bhushan_Mahajan_0-1737022353221.pngBhushan_Mahajan_1-1737022382738.png

3. Then Write expression in your measure as =if($(vPD)=0,sum({<A-={'Car'}>}Sale),Sum(Sale))