topic Re: Conditional Coloring in App Development

Conditional Coloring

amr_qlik — Fri, 11 Mar 2022 20:18:47 GMT

I'm trying to find a way to color the output of an if statement. The function I'm using is below:

if((count(distinct{$ <[Fiscal Year] = {$(=MAX([Fiscal Year]))}>}[Product Number]) -count(distinct{$ <[Fiscal Year] = {$(=MIN([Fiscal Year]))}>}[Product Number])) > 0, '▲', '▼')

I'm wanting the upward carrot to be green and the downward carrot to be red. I attempted to encase them in Red() and Green() but then it showed up a large number instead of a red/green carrot.

Re: Conditional Coloring

Aditya_Chitale — Sat, 12 Mar 2022 08:08:32 GMT

Hi @amr_qlik ,

Add this expression in text color expression of your measure:

if((count(distinct{$ <[Fiscal Year] = {$(=MAX([Fiscal Year]))}>}[Product Number]) -count(distinct{$ <[Fiscal Year] = {$(=MIN([Fiscal Year]))}>}[Product Number])) > 0, lightgreen() ,lightred() )

Regards,

Aditya

Re: Conditional Coloring

amr_qlik — Fri, 18 Mar 2022 14:55:40 GMT

I'm not seeing a text color expression box anywhere.

Re: Conditional Coloring

MarcoWedel — Fri, 18 Mar 2022 18:58:13 GMT

where do you apply this expression, i.e. what kind of object would you like to present this coloured symbol?

Re: Conditional Coloring

amr_qlik — Fri, 18 Mar 2022 19:02:33 GMT

Currently, the object is in a KPI. I'm open to it being in another object if necessary, but only if it can be made large enough to be easily seen.

Re: Conditional Coloring

MarcoWedel — Fri, 18 Mar 2022 19:15:31 GMT

At least the ▼ character might be replaced by the inherently red unicode symbol 🔻
using Chr(128315) or '🔻' instead of '▼' in your expression.
There doesn't seem to be a green ▲ though...

Re: Conditional Coloring

MarcoWedel — Fri, 18 Mar 2022 19:32:31 GMT

Defining the colours should be possible in the Appearance/Color section.

Re: Conditional Coloring

amr_qlik — Fri, 18 Mar 2022 19:40:00 GMT

Thank you. Chr(128315) combined with coloring the output green gets me where I want to be!

Is there a list of the available chr() characters somewhere I could look at?

Re: Conditional Coloring

chris_djih — Mon, 21 Mar 2022 07:25:42 GMT

You can make this list by yourself:

Symbols: Load Chr(RecNo()) as AsciiAlpha, RecNo() as AsciiNum autogenerate 20000 Where (RecNo()>=32 and RecNo()<=126) or (RecNo()>=160 and RecNo()<=13000) ; Emojis: Load Chr(RecNo()) as EmojiAlpha, RecNo() as ENum, autogenerate 130000 Where (RecNo()>=127744 and RecNo()<=128317) or (RecNo()>=128506 and RecNo()<=128591) or (RecNo()>=128640 and RecNo()<=128709) or (RecNo()>=128752 and RecNo()<=128762) ;