topic Re: Num Format Issue in Qlik in App Development

Num Format Issue in Qlik

Surya — Fri, 30 Jul 2021 10:13:38 GMT

Hello Techies,

I want Number format

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

Re: Num Format Issue in Qlik

rwunderlich — Fri, 30 Jul 2021 17:40:31 GMT

Use a format pattern like:

+0.0%;-0.0%

-Rob

Re: Num Format Issue in Qlik

Surya — Mon, 02 Aug 2021 03:05:46 GMT

Hi Rob.

when im using this format

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

-Surya

Re: Num Format Issue in Qlik

Patricia_Silva — Mon, 02 Aug 2021 14:19:46 GMT

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

Re: Num Format Issue in Qlik

rwunderlich — Mon, 02 Aug 2021 14:37:05 GMT

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-number-time-formats.htm

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

Re: Num Format Issue in Qlik

Surya — Tue, 10 Aug 2021 10:45:31 GMT

hello All,

Thanks..Im done

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