Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

like function

is there a like function in qlikview?

I have a column called "bonus_description" and it has both letters and numbers in it, for example "new member 100% bonus"

what I want is to replace all "new member 100% bonus" to just "100%" and then do the same where there is 50%, 75% etc

1 Solution

Accepted Solutions
29 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use match or wild match (see help)

Not applicable
Author

try with wildmatch() function...

look it on qv help

tresesco
MVP
MVP

Use Keepchar() / PurgeChar() function.

maxgro
MVP
MVP

=replace(' new member 100% bonus','new member', '')

Colin-Albert

Try

     trim(replace(replace(bonus_description,'new member',''),  'bonus','')) as bonus_percent

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Abbasi,

You can use Keepchar() function.

Use like this in your script

Keepchar('bonus_description','0123456789%').,

it will fetch all the records like you want.

rustyfishbones
Master II
Master II

Hi Zainab,

there are a number of options

Here are 2

PURGECHAR()

2014-01-31_1010.png

KEEPCHAR()

2014-01-31_1008_001.png

Not applicable
Author

thanks

alexandros17
Partner - Champion III
Partner - Champion III

Keep char works in this way:

keepchar ( 'a1b2c3','123' )  returns '123'

This is not "like" ...

Am I right?