Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Unveils New Agentic Capabilities Across Analytics, Data Engineering, and Trust: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Laura_Analyst
Partner - Contributor
Partner - Contributor

Conditional format for concatenated KPI values

 

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!

Labels (2)
2 Replies
Chanty4u
MVP
MVP

Try this 

If(vValue1>=0,green() ,red() ) & Num(vValue1,'0.0%')

& ' / ' &

If(vValue2>=0,green() ,red()) & Num(vValue2,'0.0%')

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

@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

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.