formatting numbers in Pixel Perfect

mstoler — Fri, 19 Aug 2022 21:24:58 GMT

Hello,

Is there a good source for the number formats in Pixel Perfect.

It seems that for Currency $0,0 works and so does $#,##0. However $0,0 does not work in Qlik. I assume the formatting is different.

I just want to make sure that I am using the correct format string.

Thank You,

Michael

Re: formatting numbers in Pixel Perfect

Ruggero_Piccoli — Mon, 22 Aug 2022 12:51:24 GMT

Hi,

PixelPerfect numbers formatting is of its editor, independent from QlikView or Qlik Sense. PixelPerfect templates follow .NET formatting and I suggest that you consult Microsoft Documentation: Custom Numeric Format Strings

Another solution could be to force QlikView or Qlik Sense to export numbers as text by using Text() function and its formatting rules.

Best Regards,

Ruggero

topic Re: formatting numbers in Pixel Perfect in Qlik NPrinting

formatting numbers in Pixel Perfect

Re: formatting numbers in Pixel Perfect