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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding an Action to a Text Object

I have the following action assigned to my text object...

Action - Select in Field

Field - [Property Type]

Search String - =if(vshow = 'HO', 'General Needs')

This works absolutely fine but I want to add two more property types to the search string and just can't seem to get the logic right.  Is that possible?  When the user is directed to the 'HO' sheet I want the property type within my Select Filters box to have already populated with 'General Needs', 'Older Persons' and 'Sheltered'.

Many thanks.


4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The syntax for multiple selections is:

("General Needs" | "Older Persons" | "Sheltered")

-Rob

Not applicable
Author

Thanks for responding so quickly Rob.  That works if I use that syntax on its own.  How do I incorporate that with the...

=if(vshow = 'HO')?  I've tried numerous combinations

Many thanks.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I believe it's:


=if(vshow = 'HO'), '("General Needs" | "Older Persons" | "Sheltered")'


Note that if() is returning a string in single quotes.


-Rob


Not applicable
Author

I've had to make a slight amend to the syntax and it's now working...

=if(vshow = 'HO', '("General Needs" | "Older Persons" | "Sheltered")')

Many thanks.