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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help

Hi,

can we change special charcters(#,@,*) to numbers(100,200,300) in qvw existing table?

I tried inputfield then it works fine but while am using combination of pick and match functions but it doesn't work.

am looking for any other ideas

Please have a look at this issue.

Rgs

satish

1 Reply
Not applicable
Author

Hi Satish,

Pick match should work. Try this expression

pick(match(incr,'#','@','*',incr),100,200,300,incr)

Hope it work!

Regards

Sana