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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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