Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

% not working in Nprinting

Dear All,

 

   I have an excel with field called sales% in my excel in which all its values will be in % but when i open the same excel in Nprinting template the values are not in % rather its like 0.342648840867748.

 

any help would be highly appreciated.

 

Regards,

Joshua.

Labels (1)
1 Reply
Frank_S
Support
Support

Hi @ajsjoshua 

First of all, you cannot change formats if you are exporting a pivot table using the 'tables' object in NPrinting Template editor. The source table must be a straight table.

Once you have a straight table, expand so you can see all the individual fields in the template editor.

Then you can deselect 'keep source formats' for each field value that wish to apply specific formats to then and apply your own formats as needed either leveraging the custom formats in MS excel or using the format property for each field value.

To expose the field 'properties' just right click on the field value under the expanded chart object in the NP designer template editor and click 'properties'

For more information regarding your requirement, check the following help pages:

https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ReportsDevelopment/Which-Formats-C...

https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ExcelReports/Excel-formatting.htm

 

 

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!