topic Re: How to incorporate performance icons into a footnote expression in App Development

How to incorporate performance icons into a footnote expression

kwschramm — Tue, 20 Feb 2024 18:30:41 GMT

I've historically use the footnote on a KPI to show prior period metrics (preferred over the 2nd KPI option and the "limit' color/symbol approach) as there is a little more flexibility (able to show both last year $ and % of change in the same footnote expression). Formatting is limited to font, font color, bold etc in presentation\styling section.

I have seen examples before where developers imbed a red down arrow and green up arrows in the footnote that introduces colors to highlight performance but I have never actually tried it. I seem to recall seeing CHR() stuff but don't have any samples.

Anyone have an example script that they can publish here? I don't see any examples anywhere in the community. If there is anything "tricky" about getting the images into the script, that would also be helpful Pretty sure they are not imported through the typical app media upload.

THANKS in advance for anyone who has some samples.

Re: How to incorporate performance icons into a footnote expression

brunobertels — Wed, 21 Feb 2024 11:25:14 GMT

Try this as custom format in your expression

▲ #,##0;▼ #,##0

it could be

num( myMesure , '▲ #,##0;▼ #,##0' )

Then add in Text Color Expression:

if(Value=1,Green(),Red())

Or using chr()

for example :

=if(sum(Revenu)-Sum(BudgetAmount)>0,chr(9650),chr(9660))

Re: How to incorporate performance icons into a footnote expression

kwschramm — Wed, 21 Feb 2024 14:15:16 GMT

@brunobertels - This is a great example and using the last sample, I am easily able to get the arrows. The only thing that I don't know how to do is color them. Here is my latest (its a little hacky but works for me).

Any ideas on the colored icons? Thanks again for your help on this.

=If ([Sales % Of Change]>0,
'Prior Period ' & Num([Sales PP],MoneyFormat) & ', UP ' & chr(9650) & Num([Sales % Of Change], '###.0%'),
'Prior Period ' & Num([Sales PP],MoneyFormat) & ', DOWN ' & chr(9660) & Num([Sales % Of Change], '###.0%'))

Re: How to incorporate performance icons into a footnote expression

brunobertels — Thu, 22 Feb 2024 08:26:26 GMT

Not sure you can apply color coding in foot line of KPI object.

So rather than use chr() you can replace it with emoji : Qliksense does support emoji.

There is a red down arrow 🔻 but no green up arrow

=If ([Sales % Of Change]>0,
'Prior Period ' & Num([Sales PP],MoneyFormat) & ', UP ' & '✔️' & Num([Sales % Of Change], '###.0%'),
'Prior Period ' & Num([Sales PP],MoneyFormat) & ', DOWN ' & '🔻' & Num([Sales % Of Change], '###.0%'))

Find emoji here : https://emojipedia.org/symbols

Re: How to incorporate performance icons into a footnote expression

kwschramm — Thu, 22 Feb 2024 14:57:31 GMT

Thank you again