Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 

NP19 Excel report always shows decimal numbers

Hi All,

We met a very weird issue and hope somebody could please provide some hints.

We have some NP19 reports which contain some fields like dates, for example 5/22/2020 or rates, for example 87% etc. Those mainly just source format from corresponding Qlikview qvw files, and all were working well before. This Monday we met some performance issue and NP report publish task was slower and slower, so our server team did reboot and clean up. But after that, all of our Excel reports just display those date or rate fields as decimal, for ex. date as 43578.12345, rate is showing 0.87. We do not make any changes to either NP report or qvws.

Are there any person ever saw this issue?

Thanks for your help.

Tags (2)
1 Reply

Re: NP19 Excel report always shows decimal numbers

The actual values are coming through as numerical (as 43578.12345 is typical for timestamp 23/04/2019 02:57:46 and 0.87  is indeed 87%), so to me this is only formatting issue, but I have never seen it happening by itself unless something has changed.

- Data coming to Qlik could change format in source

- Server regional settings changed

- Excel updates could happen

- Someone uncheck - "keep source format" in templates (although you say you did not change templates)

My approach would be to look at templates and actually see what is setup in it.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.