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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Aika
Contributor III
Contributor III
‎2021-07-20 12:20 PM

Filter values

Hi,

I have values, in a column date, like:

043689#PENLS_298610
000329#PEN_359677
000450#PEN_632580
096574#PENLS_156436
084405#PENLS_290274
...

I need to clean up the column date and get only the values that have "PENLS" inside:

043689#PENLS_298610
096574#PENLS_156436
084405#PENLS_290274
...

How can I do this using a Qlik function?
Who can help me in a short time?

657 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2021-07-21 04:32 AM

Hi

Try like below

If(wildmatch(columndatafield, '*Penls*),columndatafield, '') as columndatafield

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
600 Views
Aika
Contributor III
Contributor III
‎2021-07-27 06:47 AM
Author

Thank you, I try.

575 Views
0 Likes