Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
bc-thebruuu
Creator
Creator

N-printing not formatting in PowerPoint

Hi there

How do I set a specific format for a cell that comes with 259000 in it?

I want it to set as 259 000 €

 

no way to manage to do it?
Seems N-printing ignores my format instructions ...

Labels (1)
4 Replies
HeshamKhja1
Partner - Creator II
Partner - Creator II

Can you please identify the chart type you are creating?

In most of the NPrinting objects, there is an option to take Qlik Sense format or not. Make sure you untick it.

Keep Source Formats >> Untick.

HeshamKhja1_0-1698648310836.png

 

Aditya_Chitale
Specialist
Specialist

Have you tried setting custom number format in Nprinting excel editor template itself ?

  1. Click on the column cell and in formatting select custom. 
  2. Select #,##0 from available options and append € sign after the format after giving a blank space.
  3. Doing this will add € sign after number but calculations will be performed excluding the sign.

Regards,

Aditya

 

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

HI @bc-thebruuu 

In PowerPoint NPrinting designer template untick Keep Source Format and apply format you need (see screenshot)

More about format here: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Designer-properti...

Lech_Miszkiewicz_1-1698838658068.gif

 

cheers

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.
Frank_S
Support
Support

Perhaps this may help...

https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Number-formatting-and-multiple-Win...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!