https://community.qlik.com/t5/QlikView/How-simply-get-preceding-sign/m-p/1940460#M1219309 <P>Hi all,</P> <P>I'am looking for a little simple thing : in a text box id'like to add a preceding + ou - sign depends my kpi is negative or positive. I want avoid condition (if KPI &gt; 0, '+'&amp;KPI Value....).&nbsp;</P> <P>By default - sign appears when value is negative but no + when positive.</P> <P>Any idea?</P> <P>&nbsp;</P> Tue, 07 Jun 2022 14:13:34 GMT sergio0592 2022-06-07T14:13:34Z https://community.qlik.com/t5/QlikView/How-simply-get-preceding-sign/m-p/1940460#M1219309 <P>Hi all,</P> <P>I'am looking for a little simple thing : in a text box id'like to add a preceding + ou - sign depends my kpi is negative or positive. I want avoid condition (if KPI &gt; 0, '+'&amp;KPI Value....).&nbsp;</P> <P>By default - sign appears when value is negative but no + when positive.</P> <P>Any idea?</P> <P>&nbsp;</P> Tue, 07 Jun 2022 14:13:34 GMT https://community.qlik.com/t5/QlikView/How-simply-get-preceding-sign/m-p/1940460#M1219309 sergio0592 2022-06-07T14:13:34Z https://community.qlik.com/t5/QlikView/How-simply-get-preceding-sign/m-p/1940495#M1219311 <P>It could be reached just with a formatting like:</P> <P>=num(YourNumber, '+ #.##0,00;- #.##,00')</P> <P>- Marcus</P> Tue, 07 Jun 2022 14:45:21 GMT https://community.qlik.com/t5/QlikView/How-simply-get-preceding-sign/m-p/1940495#M1219311 marcus_sommer 2022-06-07T14:45:21Z