Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Expression for a Binary Flag?

Using Qlik Sense, I have a Dimension on the interface called something like IS Customer? and the values are Y and N.  It's just a flag. The data is there and it works.

My problem, I'm trying to get the Dimension to default to Y when the user first visits the page.

I looked at the Set Analysis videos and help guides but none of the functions seem appropriate? SUM, COUNT, MAX etc none seem to work. Any ideas? Thanks in advance

4 Replies
Miguel_Angel_Baeyens

Hi Matt,

It is that more of a trigger for an action on select. Right click on the sheet > Actions > Select in Field and specify the value and the name of the field with the flag.

You could use variables for a more flexible control, in Settings > Document Properties > Triggers

Miguel

Not applicable
Author

This is Qlik Sense not Qlik View where are Actions or Settings? When I right click on the sheet in the app overview i get   Edit, Duplicate, Delete as choices. Thanks again

b_garside
Partner - Specialist
Partner - Specialist

I'm new to QlikSense as well. This feature is really needed if its not there. Wow

Not applicable
Author

to answer my own question, i think selecting the filter value you want and "locking" the selection might work. This happens by clicking on the filter at the top dark gray bar and there is a lock icon. I don't know if this persists across all users though...