List Box to include or exclude field data

[aarohipatel]

Hello,

I want to create a list box with expression to include or exclude data value of an field.

Field: ABC_COMP

One of the Data Value is : XYZ_2020

List box should have a value: Exclude_XYZ_2020 and when this value is selected in the List box, XYZ_2020 should be excluded from the field ABC_COMP. This way, user should be able to include or exclude XYZ_2020.

I have tried:  =if(not match(ABC_COMP,'XYZ_2020'),'Exclude_XYZ_2020') 

It is working for exclude but when trying to click on it again to include the data, it is not working.

Please advise.

Thanks in advance.

[aarohipatel]

Requirement: Users should have the flexibility to include or exclude 'XYZ_2020' data from the QlikView report.

When users click on 'exclude'- data related to XYZ_2020 should be excluded from the  report. This should be displayed in the Current selection box so that when users look at the CS box, they should be aware of all the filters/exclusions applied. This also helps when exports are taken.

[Kushal_Chawda]

see the attached if it helps

[aarohipatel]

Thank you Kush. This helps if I had just a couple charts in the report so that I can modify the expression in them.

I have many charts and tables in the report. 

[aarohipatel · Accepted solution]

I found a  solution to my requirement  .

Add 2 buttons

Exclude: 2 actions a) Select in field       b) Select excluded

Include: 1 action- Clear field

Thank you for helping me gain knowledge in other options.