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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijaydurga
Contributor II
Contributor II

i have data 'a' replace 'v' i wrote in list box expression replace(feild,'a','v') it works but i want replace b,c,d how can i do it

Vijaydurga_0-1638384512891.png

 

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

You can solve this with nested replace(), like this:

replace(replace(replace ([feild],'a','v'), 'b','v'), 'c','v')

It might be more pretty to fix this in the script. I the script you can solve this using  the nested replace() as shown above, but there I would prefer using a mapsubstring()

 

View solution in original post

1 Reply
Vegar
MVP
MVP

You can solve this with nested replace(), like this:

replace(replace(replace ([feild],'a','v'), 'b','v'), 'c','v')

It might be more pretty to fix this in the script. I the script you can solve this using  the nested replace() as shown above, but there I would prefer using a mapsubstring()