Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

How to lock a field value using variable

Hi 

I am interested in locking a field value with the help of a variable. For eg if I want a selected filter has two values 'yes' and 'no ' and I want to give users only  single option (NO) to select the other value I want to lock/disable 
How can we achieve this?

I want to the user can only select 'No' for flag field and other option ie' YEs' should be disabled for selection. How can this be achieved

?

sakshikaul_0-1694695317460.png

 

Labels (6)
11 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

You can check "Always one selected value" in properties

 

Aurelien_Martinez_0-1694696352044.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

No, but this is allowing me to select the other option as well but I want user can only select 'NO' other option'Yes' should be disabled/locked for the user . The user should not able to select Yes

 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Ok, you can:

add "hide excluded"

Aurelien_Martinez_0-1694697321489.png

 

or create a new flag with only No option for user and you, you can use the old one.

or add a section acces with a restriction on this flag (no for all user and Yes/No for you)

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

Selecting 'hide excluded' option is working fine but I am not able to see the' YES' option. I want the Yes option should be there but user cannot select it 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

or you can "Lock" your selection on No. But I think user can unlock

 

Aurelien_Martinez_0-1694698282140.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

This user can unlock that is the reason I want to create a variable in which i can call lock trigger and the with the help of variable I can manage selection of field in the list box 
Is that possible?

 

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

You can try with Field event triggers (in Settings>Documents Properties>Triggers)

Aurelien_Martinez_0-1694700671784.png

 

Help users find answers! Don't forget to mark a solution that worked for you!
sakshikaul
Creator II
Creator II
Author

Can you please tell me what am I required to do?

in Settings>Documents Properties>Triggers)

I have selected 'onAnySelect' option -> then I selected selection in field-->'flag' -->search string -> 'No'

sakshikaul_0-1694701593396.png

What are the next steps am i required to do?

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

I have create a "Filed Event Triggers" on Flag field to Lock when user unlock

 

Aurelien_Martinez_0-1694702043539.png

 

Help users find answers! Don't forget to mark a solution that worked for you!