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: 
P_qlik
Partner - Contributor III
Partner - Contributor III
‎2021-04-02 05:05 AM

qlik nprinting shows a lot of 0 after an integer number

Hi, I've a table in excel, in a field that is an integer number, in excel report it is shows with a lot of 0 after ,

For example number 5 is shown as 5,000000000000

I've tried to change cell format into text, into decimal numberbut it doesn't work, how can I do?

Thank you

Labels (2)
Labels
298 Views
0 Likes
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support
‎2021-04-02 06:11 AM

Hi,

If you want to customize the format of the number in an Excel template you have to remove the Keep source format flag for that field. Refer to https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Designer-pro....

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

277 Views
0 Likes
1 Reply
Ruggero_Piccoli
Support
Support
‎2021-04-02 06:11 AM

Hi,

If you want to customize the format of the number in an Excel template you have to remove the Keep source format flag for that field. Refer to https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Designer-pro....

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.
278 Views
0 Likes