How to lock data in set analysis

Antimo92 · ‎2023-04-20

Hi everyone,

I would like to edit a sheet so that when you open it, a filter is automatically applied.
To do this I added an action in the sheet with the following set analysis:

=if(GetSelectedCount ([Country]) = 0,'Italy',GetFieldSelections([Country],';',999))

Stakeholders would like a padlock to appear when the filter is applied and I would like to do so by inserting this command in the previous set analysis.
Do you know if there is a command that allows you to apply the padlock?

PrashantSangle · ‎2023-04-20

use bookmark.

or add button in the sheet and use action as per need.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Antimo92 · ‎2023-04-20

Hi,

I did it. I added the action "Select values in a filed" with the formule I wrote and "Lock a specific field".

The problem is when you open the sheet the filter and padlock work, then when you change the selection and get back to the sheet the selection doesn't change but appers the padlock.
I would like the padlock to appear only at the beginning, if you then remove it it must not return.

General Question