
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unicode character needed for 'fa-smile-o', 'fa-frown-o', 'fa-meh-o' in Qlik Sense
Hi Team,
I have requirement where i have to create above smileys based metric values. using below expression to generate the same.
if(Metric='A' or Metric='B' or Metric='C' or Metric='D',null(),
if(
(column(2)- column(3))/column(3) >0,
chr(9787),
if(
(column(2)- column(3))/column(3) <0 and (column(2)- column(3))/column(3) >=-5,
chr(9787),
''
)
)
)
chr(9787) is generating this symbol. In the same fashion need codes for 'fa-frown-o', 'fa-meh-o'
Please suggest.
Thanks
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
works for me though
Kindly close this thread by marking a response as a "Solution"
If a post helps to resolve your issue, please accept it as a Solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use below site
https://www.alt-codes.net/smiley_alt_codes.php
Also you don't need to use character codes, you can just copy paste the smiley itself =
🙃
If a post helps to resolve your issue, please accept it as a Solution.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
kindly mark the response as "accepted solution" to close the thread
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi vinieme,
I am not able copy paste all smiles to Qlik Expression editor. For some smileys its pasting as "?" symbol. Any idea on this.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
works for me though
Kindly close this thread by marking a response as a "Solution"
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @vish123 , it might be your operating system not supporting that smiley. Are you able to copy and paste it anywhere else?
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you vinieme for your help.
I am closing this thread now.
