Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vish123
Creator III
Creator III

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'

vish123_0-1650261877952.png

Please suggest.

Thanks

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

works for me though

qlikCommunity.PNG

 

Kindly close this thread by marking a response as a "Solution"

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

6 Replies
vinieme12
Champion III
Champion III

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 = 

🙃

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

kindly mark the response as "accepted solution" to close the thread

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vish123
Creator III
Creator III
Author

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. 

vinieme12
Champion III
Champion III

works for me though

qlikCommunity.PNG

 

Kindly close this thread by marking a response as a "Solution"

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Daniele_Purrone
Support
Support

Hi @vish123 , it might be your operating system not supporting that smiley. Are you able to copy and paste it anywhere else?

Daniele - Senior Technical Support Engineer & SaaS Support Coordinator at Qlik
If a post helps to resolve your issue, please accept it as a Solution.
vish123
Creator III
Creator III
Author

Thank you vinieme for your help.

I am closing this thread now.