topic Re: Nprinting Word Report - Table cell formatting in Qlik NPrinting

Nprinting Word Report - Table cell formatting

sharanqlik — Thu, 13 Mar 2025 07:35:19 GMT

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.htm

https://community.qlik.com/t5/Official-Support-Articles/NPrinting-Word-tables-with-Source-Formats-and-table-borders/ta-p/1820322

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

Re: Nprinting Word Report - Table cell formatting

Frank_S — Thu, 13 Mar 2025 17:19:55 GMT

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/table.htm#anchor-3

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-supported-NP.htm#objects

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

Kind regards

Re: Nprinting Word Report - Table cell formatting

sharanqlik — Tue, 18 Mar 2025 09:39:06 GMT

@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

Re: Nprinting Word Report - Table cell formatting

Lech_Miszkiewicz — Wed, 19 Mar 2025 04:16:27 GMT

Hi @sharanqlik

They apply.

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

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