Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
yashas_tr
Contributor
Contributor

How to filter rows with special characters in qlik sense?

Hi I am new to qlik sense. I wanted to filter out the rows from qvd directly which contains any  special characters.Please suggest.

4 Replies
tresesco
MVP
MVP

Try like:

 

... where not findoneof(<yourfield>, 'special characters list')

 

baarathi
Creator III
Creator III

Do you want filter special character as well as numbers?

yashas_tr
Contributor
Contributor
Author

I want to filter out only rows with special characters.

baarathi
Creator III
Creator III

where findoneof(<yourfield>, 'special characters list') > 0