Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is there a way to remove cell color from exports (so the background is white) when you have a calculated background color being used for chart colors?
When I export my data, one of my columns contains the colors of my calculated background. Does qlikview provide a way to remove the colors from excel exports?
Thanks,
Rose
unfortunately i think there is no way to remove cell format when you export in an excel file.
only in print option you can remove the cell color format.
I believe the other poster is correct on this one, but I am including Help link for you to have a direct look yourself to see if you want to play with anything to check on impact. The only other thing of which I can think would be to have a button object and a copy of the chart without colors that is hidden that you could use to do the export as a workaround on this one.
Regards,
Brett