Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
nithin_miryala
Creator
Creator

background color in Pivot table not printing the colors

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.

Colorsnot displaying.JPG

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

Any thoughts on why this is happening?

Thanks

Nithin

5 Replies
Qrishna
Master
Master

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

nithin_miryala
Creator
Creator
Author

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


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

Qrishna
Master
Master

check

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

Silviya_Angelova
Contributor II
Contributor II

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?

shlomoh
Contributor III
Contributor III

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