https://community.qlik.com/t5/App-Development/kpi-object-how-to-set-conditional-color-limit-on-something-other/m-p/1514519#M36673 <P>I am working in Qlik Sense Enterprise 3.2.&nbsp; I have a strange requirement on a kpi object.&nbsp; The user wants the kpi to change color according to its value.&nbsp; If it's positive, he wants red; if it's negative, he wants green.&nbsp; In itself, that's super easy: just set a conditional color limit (at value = 0, with positive red, and negative green).&nbsp; However, he also wants the measure to always display as a positive number (even&nbsp;when it's really a negative number), which conflicts with the conditional color limit because the conditional color limit references the actual value of the measure, not the display value.&nbsp; In fact, more generally, I think the real issue here is that he wants 2 values for the measure -- a computed value and a display value -- which I don't think can be achieved in Qlik Sense.</P><P>So, for example, the measure returns a negative number.&nbsp; He wants the measure label to read something like "decreased", the value to display as a positive number (to not confuse the user with the "decreased" verbiage), and the measure value to appear in green.&nbsp; If the measure returns a positive number, he wants the measure label to read something like "increased", the value to display as a positive number, and the measure value to appear in red.</P><P>Is it possible to achieve these seeming conflicting requirements?</P> Sat, 16 Nov 2024 07:10:13 GMT skyline01 2024-11-16T07:10:13Z https://community.qlik.com/t5/App-Development/kpi-object-how-to-set-conditional-color-limit-on-something-other/m-p/1514519#M36673 <P>I am working in Qlik Sense Enterprise 3.2.&nbsp; I have a strange requirement on a kpi object.&nbsp; The user wants the kpi to change color according to its value.&nbsp; If it's positive, he wants red; if it's negative, he wants green.&nbsp; In itself, that's super easy: just set a conditional color limit (at value = 0, with positive red, and negative green).&nbsp; However, he also wants the measure to always display as a positive number (even&nbsp;when it's really a negative number), which conflicts with the conditional color limit because the conditional color limit references the actual value of the measure, not the display value.&nbsp; In fact, more generally, I think the real issue here is that he wants 2 values for the measure -- a computed value and a display value -- which I don't think can be achieved in Qlik Sense.</P><P>So, for example, the measure returns a negative number.&nbsp; He wants the measure label to read something like "decreased", the value to display as a positive number (to not confuse the user with the "decreased" verbiage), and the measure value to appear in green.&nbsp; If the measure returns a positive number, he wants the measure label to read something like "increased", the value to display as a positive number, and the measure value to appear in red.</P><P>Is it possible to achieve these seeming conflicting requirements?</P> Sat, 16 Nov 2024 07:10:13 GMT https://community.qlik.com/t5/App-Development/kpi-object-how-to-set-conditional-color-limit-on-something-other/m-p/1514519#M36673 skyline01 2024-11-16T07:10:13Z https://community.qlik.com/t5/App-Development/kpi-object-how-to-set-conditional-color-limit-on-something-other/m-p/1514557#M36676 You can use show hide container extension to create two object, one with red color and other with green then write condition in show hide if value &amp;gt; 0, green will be displayed else red will be displayed.<BR /><BR />Hope this might help you get through the users requirement. Fri, 30 Nov 2018 01:36:06 GMT https://community.qlik.com/t5/App-Development/kpi-object-how-to-set-conditional-color-limit-on-something-other/m-p/1514557#M36676 bharatchauhan 2018-11-30T01:36:06Z