topic Re: Adding an Action to a Text Object in QlikView

Adding an Action to a Text Object

Thu, 22 Oct 2015 13:13:23 GMT

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.

Re: Adding an Action to a Text Object

rwunderlich — Thu, 22 Oct 2015 13:21:16 GMT

The syntax for multiple selections is:

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

-Rob

Re: Adding an Action to a Text Object

Thu, 22 Oct 2015 13:48:48 GMT

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.

Re: Adding an Action to a Text Object

rwunderlich — Thu, 22 Oct 2015 14:04:34 GMT

I believe it's:

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

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

-Rob

Re: Adding an Action to a Text Object

Thu, 22 Oct 2015 14:12:45 GMT

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.