Discussion Board for collaboration on QlikView Layout & Visualizations.
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
But if I want to filter on, for example, "Not Delivered", I don't seem to succeed.
(A|B|C|Not Delivered)(A|B|C|'Not Delivered')
with no outcomes.
Any hint here?
Go to Solution.
Double quotes should do it:
Hope this helps!
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!