topic upon open document, selection of strings with spaces in QlikView

upon open document, selection of strings with spaces

Wed, 11 Dec 2013 16:28:06 GMT

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!

Re: upon open document, selection of strings with spaces

jerem1234 — Wed, 11 Dec 2013 16:33:49 GMT

Double quotes should do it:

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

Hope this helps!

Re: upon open document, selection of strings with spaces

Fri, 13 Dec 2013 11:51:43 GMT

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!