Num Format Issue in Qlik

[Surya]

Hello Techies,

I want Number format 

If positive +7,3 else  -7.3 Please find below final format 

[rwunderlich]

Use a format pattern like:

+0.0%;-0.0%

-Rob

[Surya]

Hi Rob.

when im using this format 

Actaul values is +77,4 but it shows +7,7

-Surya

[Patricia_Silva]

Hello @Surya, would you have a sample app so I can try to test it? Thank you 🙂

[rwunderlich]

I forgot the #. And I also have trouble getting the "," as decimal separator on my US machine. But my point was that the format mask provides for both positive and negative formats. 

+#0,0%;-#0,0%

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Introduction/conventions-...

https://qlikviewcookbook.com/2014/05/the-third-format/

[Surya · Accepted solution]

hello All,

Thanks..Im done

'+'& replace(Num(val,###%),'.',',')