Columns in pivot table do not keep background color

[midnight1]

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

[rubenmarin]

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.

[Lech_Miszkiewicz]

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

[Ruggero_Piccoli]

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