topic Re: How to use Unicode with the Repeat Function in App Development

How to use Unicode with the Repeat Function

crichter14 — Sat, 16 Nov 2024 18:26:26 GMT

Patric Nordström presented this in his tips & tricks from 2019, and I was wondering

I can change his code from:

Repeat('▮',round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*10))

Repeat('💍',round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*10)) and it works.

But what if I only had the unicode? How do I put that into the original line of the expression?

U+1F48D

Thank you in advance,

Cheryl

Re: How to use Unicode with the Repeat Function

QlikTom — Fri, 26 Jun 2020 15:52:09 GMT

You can use the CHR() function in combination with the Unicode point number.

In this case 💍 = 128141

So in your case it would be:

Repeat(chr(128141),round(sum(Sales)/max(total aggr(sum(Sales), CategoryName))*10))

On most reference sites, the unicode point number is listed under "HTML code" or "HTML entity", but all you need is the integer number.
https://unicode-table.com/en/1F48D/

CHR function:
https://help.qlik.com/en-US/sense/latest/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/Chr.htm

You can discover the unicode point number of a symbol by using the ORD() function:
https://help.qlik.com/en-US/sense/latest/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/Ord.htm

Re: How to use Unicode with the Repeat Function

Saravanan_Desingh — Fri, 26 Jun 2020 18:49:02 GMT

Thanks for the information @QlikTom

Re: How to use Unicode with the Repeat Function

crichter14 — Tue, 30 Jun 2020 12:51:49 GMT

Thank you Qliktom!

Re: How to use Unicode with the Repeat Function

QlikTom — Tue, 30 Jun 2020 13:44:57 GMT

One more bit of relevant information. Whenever you see a unicode symbol/emoji it is typically listed in hexadecimal like so:

U+1F48D

If you parse out the section after "U+" you will find this is just a hexadecimal number. This can be converted to the decimal number you need on any number of websites or even with the windows calculator in "Programmer" mode.

Example:

Re: How to use Unicode with the Repeat Function

crichter14 — Tue, 14 Jul 2020 23:41:36 GMT

Thank you Tom!! that's so helpful!

Re: How to use Unicode with the Repeat Function

IgorManzhin — Tue, 31 Aug 2021 08:52:53 GMT

Hello all, thank you. Sorry a lot, could you explain how to be with the green triangles. For red triangles i found chr (128314), chr (128315), but there is no way with greens.