topic How to select multiple string values in a field on document load trigger in QlikView

How to select multiple string values in a field on document load trigger

konidena — Fri, 19 Feb 2016 08:27:11 GMT

Hi Team,

Here i attached the qvw file for more clarity.

I have to add a trigger in document properties.

Trigger is for "On Open"

Requirement:

I have name column, salary column

Name Salary

ramu 3000

srinivasa rao 2000

vikas 5000

I used the expression in the trigger ='('&'srinivasa rao'&'|'&'ramu'&')'

It is selecting only 'ramu' on qvw open.

If i give "vikas" and "ramu" then it is selecting both.

I am assuming, there is issue with the space in the name "srinivasa rao". How to handle this space.

Regards

Srinivas

Gysbert_Wassenaar — Fri, 19 Feb 2016 10:36:39 GMT

Try ='("srinivasa rao"|"ramu")'

Chanty4u — Fri, 19 Feb 2016 10:41:28 GMT

chk dis

sunny_talwar — Fri, 19 Feb 2016 10:52:18 GMT

This should work also:

("srinivasa rao"|"ramu")

The idea is that when you have space between your search string, you need to use double quotes around the search string.

This should also work:

("srinivasa rao"|ramu)