Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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