Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If Function with a special character

Hello,

Im having trouble with an If( Function in my Qlikview Load.

In the datafiles, its possible to select 'favorite' fields that are marked with a star symbol in the
Qlikview Logfiles. The character code for that star is: chr(9734)

2016-12-20_8-04-36.png

Now I want it to be possible that I delete the star symbol when its occurring in the table value.
I used an If( function like this: If(Wildmatch(Message, chr(9734)), PurgeChar(Message, chr(9734)))

But it didn't work.
Maybe its part of the If function or the Purgechar that wont work.

Anyone can help me with this issue?

Thanks in Advance!

Ivo

10 Replies
Not applicable
Author

This doesnt work unfortunately, because it will also do a purgechar on every single _, C, h, a, r, t,  too.
Theres a text behind the Chart: ☆ that get completely messed up by the purgechar function, so I guess its best to go with the multiple replaces for now.


Thanks for your input though!