Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Make set analysis selection of value containing hyphen

Hi,

In my set analysis expression I have to include the selection of a field containing a  value which has a hyphen in the middle

e.g. company={A-Z}

But QV is reading the hyphen as a minus, the selection doesn't work. I can't change the underlying data to remove the hyphen or replace it with another symbol, so the solution has to be in the expression. I've tried to enclose the value in ' ' or [ ] but without joy.

Does anyone have a suggestion? And sorry in advance but I can't post an example.

Many thanks in advance for anyone with a great idea or a solution.

Neil.

1 Solution

Accepted Solutions
Not applicable
Author

Have you tried {"A-Z"}?

View solution in original post

3 Replies
Not applicable
Author

Have you tried {"A-Z"}?

Not applicable
Author

Wish I had thought of that one. Works perfectly Robert. Thank you very much.

Not applicable
Author

No problem!  Good luck!