Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mstoler
Partner - Specialist
Partner - Specialist
‎2022-08-19 05:24 PM

formatting numbers in Pixel Perfect

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

 

Labels (2)
Labels
339 Views
0 Likes
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support
‎2022-08-22 08:51 AM

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

301 Views
1 Reply
Ruggero_Piccoli
Support
Support
‎2022-08-22 08:51 AM

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
302 Views