Nprinting Word Report - Table cell formatting

[sharanqlik]

I have a Qlik sense table with cell conditional formatting for text / background color (like red for +ve numbers and green for -ve numbers).

I want to get the same table (with conditional formatting) in a NP Word doc. 

Now

1. if I keep source formatting, the table borders etc go away and it does not look good in word document.

2. if i uncheck 'keep source format' then table looks fine but the cell formatting is not applicable (no red and green colors)

I have already tried with no luck -

https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/WordReports/Format-Word-Reports...

https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Word-tables-with-Source-Formats-an...

This use to work fine with QV (I had all the table formatting in QV and use the table as is with source format) but with Qlik sense, its a problem.

Can someone please help

Qlik NPrinting  Qlik Sense Enterprise on Windows 

[Frank_S]

For information about working with Qlik Sense tables please visit:

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/Table...

Also check the known limitations for working with Qlik Sense objects where NPrinting is concerned here:
https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/ReportsDevelopment/Qlik-objects...

Others here in this forum may have specific solutions or workarounds.

Kind regards

[sharanqlik]

@Frank_S  thanks for your reply but none of the limitations mentioned applies to my problem statement. The link that you have shared is for table building is for Qlik Sense. I have no problem is creating required table in Qlik sense but rendering it with bordered table in NP word document is issue here which I am asking help for

[Lech_Miszkiewicz]

Hi @sharanqlik 

They apply.

As always with NPrinting you need to be aware of all limitations. So to break it down:

1. If you want to keep conditional formatting from Qlik Sense - you will not be able to retain formatting of borders and alignment and font: All other formatting options (such as table borders, text alignment inside cells, text formatting) are not supported.
2. If you disable Keep Source Format - you will be able to apply MSWord formatting to a table but will have no ability to control colour of font and background etc.

Bottom line is: knowing this limitation gives you straight answer that what you ask is not possible as either way you will not get a format you want.

Now, the main question is:

• why do you need MsWord template
• what is your final output format
• what alternatives you have
• can you use other template format - and why not go for pixel perfect or excel?

When designing NPrinting report you always start from the output and you make decisions during design process on which template to use and what approach to take to achieve best possible result. 

cheers

Lech