topic Re: Exclude one value in a filter and integrate it in a bookmark in App Development

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

alex59800 — Mon, 02 Dec 2024 09:14:45 GMT

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

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

sbaro_bd — Tue, 03 Dec 2024 11:02:13 GMT

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.

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

Or — Tue, 03 Dec 2024 11:34:34 GMT

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)