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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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