Excel Tables are not keeping the colors after importing

[clarcombefmsb]

Hello,

I've been trying to import my Qliksense pivot tables as excel files. Everything works except the background colours for the cells are not being imported.

How can I change this

This is what I have in Qliksense

This is what I get in Excel

These are my settings

Using Qlik Nprinting May 22 edition

[Lech_Miszkiewicz · Accepted solution]

Hi, What you are trying to do is not possible. Export from pivot tables does not support colours export.

Alternatives are:

• export table as an image - poor results in my opinion
• export data from Qlik Sense pivot table and use excel conditional formats to colour code- poor results in my opinion
• export data as straight table to excel and built excel based pivot table with all required formats - the best possible results.

Steps on how to do those are on https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ExcelReports/Pivot-table-Excel.htm

cheers