Qlik Sense table, how to add an expression with smileys (images) instead of numbers ?
To make a table more readable, I would like to add conditional smileys according to the KPI, things generally done for a dashboard, but I do not find what function in an expression would allow me to use images from the media library of the application
Simple example :
if my KPI < 80% then load the bad smiiley if my KPI between 80% and 120%, then no smiley if my KPI > 120% then load the good smiley
For some reason, I can't upload the app. But you can re-create it by installing the extension and then using the following code in the data editor (replace the server name and image names with your server name and image names in the Image and Image2 columns):
SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;($#,##0.00)'; SET TimeFormat='h:mm:ss TT'; SET DateFormat='D/M/YYYY'; SET TimestampFormat='D/M/YYYY h:mm:ss[.fff] TT'; SET FirstWeekDay=6; SET BrokenWeeks=1; SET ReferenceDay=0; SET FirstMonthOfYear=1; SET CollationLocale='en-SG'; SET CreateSearchIndexOnReload=1; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';