Exclude one value in a filter and integrate it in a bookmark

[alex59800]

Hello

In Qliksense I need to exclude only one value in a bookmark, but i am afraid of if , i relaod new datas, my bookmark exclude also those new datas.

Is there a solution ? 

I remember in Qlikview, you could apply a not wildmatch in a filter as search and store it in a bookmark, but it is not working anymore in Qliksens.

Thank you for your help

Best regards

Cd

[sbaro_bd]

Hello @alex59800 ,

Indeed, this behavior isn't available in Qlik Sense like in Qlikview. But you can use a workaround with a button. Take a look to the attached file.

Regards.

[Or]

You can set your bookmark using a formula rather than value selection, then hit enter on the keyboard (do not select values with your mouse) to apply the formula.

e.g. search the field in question and use:

=db=concat({< db -= {db_4} >}db)