topic Re: Columns in pivot table do not keep background color in Qlik NPrinting

Columns in pivot table do not keep background color

midnight1 — Fri, 20 Jun 2025 12:58:49 GMT

Hi!

I have a straight table in QLik Sense and I built such table in QlikNprinting and then form it I wanted to built pivot table.
I changed headers to be blue but values columns does not keep that color:

but when data is added:

here are my settings:

keep source format also turned off for columns.
how can i make it work?

Qlik NPrinting February 2024 SR3

Version: 24.4.14.0

Re: Columns in pivot table do not keep background color

rubenmarin — Sat, 21 Jun 2025 06:44:45 GMT

Hi, you can try setting the 'Show headers' option to Hide.

Also confirm that the columns of the table has the 'Keep Source Formats' disabled, the screenshot is from the table, but maybe the column has a different configuration.

Re: Columns in pivot table do not keep background color

Lech_Miszkiewicz — Sat, 21 Jun 2025 13:42:11 GMT

Hi @midnight1

Not sure i understand the issue.
Best practice is to create excel pivot table based on data from straight table. Then you can set the style of the pivot table which is an excel property itself. I am not talking about formatting cells but actually applying table style to pivot table.
cheers

Re: Columns in pivot table do not keep background color

Ruggero_Piccoli — Mon, 23 Jun 2025 09:37:14 GMT

Hi,

If the issue is with a native Excel pivot table created with data from a Qlik Sense straight table, the problem is related to Excel formatting. I suggest you to investigate native Excel pivot table formats and apply them.

If you export a native Qlik Sense pivot table into Excel some formats could be lost and this is a known behavior and the reason why @Lech_Miszkiewicz suggested to create native Excel tables instead.

Best Regards,

Ruggero