topic Unicode character in textbox in QlikView

Unicode character in textbox

Wed, 14 May 2014 09:23:59 GMT

Hello,

I'm trying to write a Unicode character (Unicode number: U+21BA) in a Text box

=chr(Num#('U+21BA', '(HEX)'))

I know the format code is not in 'HEX', what should I use?

Thanks in advance,

Francisco.

Re: Unicode character in textbox

simondachstr — Wed, 14 May 2014 09:28:18 GMT

Try Chr(8634) - is that what you want to achieve?

Re: Unicode character in textbox

Wed, 14 May 2014 09:39:44 GMT

Perfect, Thanks!

How did you convert the unicode to a number?

Re: Unicode character in textbox

Wed, 14 May 2014 09:44:52 GMT

I found out, using the html code, thanks!

Re: Unicode character in textbox

naberdaan — Sun, 07 Mar 2021 07:07:55 GMT

While seaching for the same thing, I found two websites that were very usefull to me. The first one might help you find the character/emoij you are looking for. The second will help you convert the Unicode to a number that you van use in Qlik.

1. https://emojipedia.org
2. https://r12a.github.io/app-conversion

Just paste the Unicode in the green area and press convert. You need part (numbers only) of the result shown in Decimal NCRs. E.g.

Unicode: U+1F44D
Decimal NCRs: 👍
Chr(128077) = 👍