Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
syedmazhar
Contributor III
Contributor III

IF i tap on the button it should exclude the values from chart.

Suppose  i have a country column and i have added a button on the top to filter in the chart.

EXM: When i open the report all the country's values should be displayed and when i tap on the button some of the country's should be excluded. 

1. India

2.USA

3.Japan

4.China

5.Russia

6.UAE

after i tap on exclude button(Exclude China,India,Japan).

Result:

1.USA

2.Russia

3.UAE

 

Please help me to achieve this.

 

Thanks in Advance.

 

3 Replies
chrismarlow
Specialist II
Specialist II

Hi,

Manually apply your selections/exclusions and save a bookmark (bookmarks - add bookmark).

Add a button (new sheet object - button), add an through the actions tab of the properties of the button to apply the bookmark (add action, bookmark, apply bookmark, bookmark id).

Cheers,

Chris.

syedmazhar
Contributor III
Contributor III
Author

Can this be done using variables?I have some 500 values to exclude from more the 2k records.

Is there any other way to implement this functionality.

 

Thanks  in advance.

chrismarlow
Specialist II
Specialist II

Hi,

So I am assuming you don't have 2k different countries, rather you are looking at a table with 2k rows where country is a dimension … Smiley Happy.

You should add a list box for the country field and make the selection through that. If you have a long list to apply you can use advanced search, so from the example you gave;

20190216_1.png

You can then save your bookmark & add to the button.

Hope that helps.

Cheers,

Chris.