Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
I have a main KPI with a secondary KPI that is built by concatenating two percentage values.
I would like each percentage to appear in green or red depending on whether its value is positive or negative.
Does anyone know if this is possible in Qlik Sense?
Thanks in advance!
Try this
If(vValue1>=0,green() ,red() ) & Num(vValue1,'0.0%')
& ' / ' &
If(vValue2>=0,green() ,red()) & Num(vValue2,'0.0%')
@Chanty4u - Please check your answers if you are unsure. What you have suggested does not make sense as colour expressions cannot be concatenated in KPI object, so your solution is not possible and looks more like AI hallucination.
@Laura_Analyst - This is not possible with a out of the box KPI object. Alternative is to use text object and have each element / measure calculated individually with individual capability of colouring it. Effectively if you want to assign colour to a text or measure that colour will apply to whole result.
cheers
.