Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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
Valued Contributor II

Re: upon open document, selection of strings with spaces

Double quotes should do it:

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

Hope this helps!

2 Replies
jerem1234
Valued Contributor II

Re: upon open document, selection of strings with spaces

Double quotes should do it:

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

Hope this helps!

Not applicable

Re: upon open document, selection of strings with spaces

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!