Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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...