Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

upon open document, selection of strings with spaces

Dear all,

I am setting up some rules to have the QVW open with some selection already pre-made through the following menu:

Document>>Triggers>>On Open>>Actions>>Select in Field

but I am finding difficulties in inputting strings with spaces in between

As long as I input a series of letters or single words, it goes fine. For example

(A|B|C|Delivered)

But if I want to filter on, for example, "Not Delivered", I don't seem to succeed.

I tried

(A|B|C|Not Delivered)
(A|B|C|'Not Delivered')

(A|B|C|<Not Delivered>)

with no outcomes.

Any hint here?

thanks!

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

Double quotes should do it:

(A|B|C|"Not Delivered")

Hope this helps!

View solution in original post

2 Replies
jerem1234
Specialist II
Specialist II

Double quotes should do it:

(A|B|C|"Not Delivered")

Hope this helps!

Not applicable
Author

thank you so much!

i always get annoyed when I play a lot in QV and I do then something in Excel, since I input everywhere single quotes instead of the " that Excel is using.

So now I am really surprised to see that in this case, we have to input the double quotes to have QV understand that string as a unique one!