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

Always one specific value is selected in the list box along with the other selections

How can I have one value always selected in the list box.

In the below tables, when I make any selection in the Region, I want APAC to be selected along with my selections. Similarly when I make any selection, in Market Sector, I should have the FI selected along with the selections I want.  When I don't select anything from the Region or Market Sector, then it should not select anything. Thanks for the help.

Region

North America
APAC
EMEA
LATAM
Market Sector
FI
ABC
SF
Copr
12 Replies
chaper
Creator III
Creator III

Ok So it is based on Region.Solution provided by sunindia‌ should work

sunny_talwar

You need this action:

='(' & Chr(34) &'APAC' & Chr(34) & '|' & If(GetSelectedCount(Region) >0, Concat(Chr(34) & Region & Chr(34), '|') & ')', ')')

Not applicable
Author

Perfect. Thanks so much Sunny.