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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional Column Hide based on Mulitple Selections of List box

I created inline data to populate a list box

Load * Inline [
Display
Change
Percent
];

I want to allow the user to hide columns in a straight table. I can hide a single column using Presentation Conditional with an IF Statement if(Display = 'Change' ,0,1)



However I am unable to use Like And etc to hide when the the user selects BOTH Change and Percent. What syntax would I use in the if statement to allow both columns to be hidden when the user selects both values in the list box?

Appreciate any advise.

2 Replies
Not applicable
Author

Try:

=if(FindOneOf(GetFieldSelections(Display), 'Change'), 0, 1)


When multiple items are selected, I needed to use GetFieldSelections on the field instead of just using the field name directly.

Not applicable
Author

Hi

something similar, used a macro to check on selected items

Jürg