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

Qlikview select values in column - selection drop down

I have a drop down selection Indicator (small triangle on field name) on field that allows me to select by typing characters on clicking that triangle.

country.png

I have some other fields which has strings with alphabets and special characters like question marks, stars, plus sign etc. I am able to select the alphabets through selection by typing alphabets in selection dropdown

for e.g if I type "a" , all the strings with "a" in them shows up .

But I am unable to search the special character values.

so for instance if I type "?" , nothing shows up as a result in search.

Is there a way that I can search for these special characters in values?

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

It may not be pretty, but you can use this function in the search:

=index(Country, '?')

=index(Country, '+')

...etc

Hope this helps!

View solution in original post

2 Replies
jerem1234
Specialist II
Specialist II

It may not be pretty, but you can use this function in the search:

=index(Country, '?')

=index(Country, '+')

...etc

Hope this helps!

Not applicable
Author

Thank you so much ..!! It worked