topic Re: background color in Pivot table not printing the colors in QlikView

background color in Pivot table not printing the colors

nithin_miryala — Wed, 28 Feb 2018 22:02:05 GMT

Hi everyone,

I have an expression with conditional background color depending on the other expressions. Everything is good there.

When i try to print that, The printed copy doesn't have the colors on it just blank cells no colors.

Exporting to excel is working fine.

Quick view of my pivot Table.

I am not able get a way around or Understand why its happening??

Any thoughts on why this is happening?

Thanks

Nithin

Re: background color in Pivot table not printing the colors

Qrishna — Wed, 28 Feb 2018 22:33:50 GMT

Try checking the properties of the printer.

i had this issue while printing pdf reports,it was because my printer color settings were 'gray and default'.you have to change those settings as per the needs.

let me know once you do that.

Krishna

Re: background color in Pivot table not printing the colors

nithin_miryala — Wed, 28 Feb 2018 22:44:44 GMT

The Color Settings on Printer are not defaults to 'gray and default'.

And i usually i print other colored stuff and its fine.

Re: background color in Pivot table not printing the colors

Qrishna — Wed, 28 Feb 2018 23:30:02 GMT

check

Go to > Menu Tab "Settings" > User Preferences > Chart Colors > Select Radio Box "Force Color" instead of 'Use Chart Settings' and let me know.

Re: background color in Pivot table not printing the colors

Silviya_Angelova — Mon, 29 Jul 2019 14:34:06 GMT

I see it is a Qlik View topic but I have the same problem with Qlik Sense. I think it has nothing to do with the printer but with the export itself. When I try to export the colored Tablix to Excel no colors are present there(no printer is included in this task to point the finger at its settings). Any new ideas on this topic?

Re: background color in Pivot table not printing the colors

shlomoh — Sun, 26 Sep 2021 13:36:11 GMT

You can do this and much more, using LogiExport extension for QlikSense
https://logiexport.logsys.co.il/documentation