topic Printout does not match pivot table properties in QlikView

Printout does not match pivot table properties

mbourges — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I'm editing a pivot table that I then print on a PDF. I want to hide some of the values in certain columns when they're not the first line of the expression, so I'm using a if statement on the color: if(line_attribute_number>1,RGB(256,256,256)).

On the sheet that I use to create the objects and manage them, it looks fine; but when I edit the report or print it, the color configuration is not taken into account.

Correct format

Printout

If any one has a solution or an idea on what to investigate, I'll take it!

Thanks!

Re: Printout does not match pivot table properties

rubenmarin — Thu, 07 Mar 2019 20:53:30 GMT

Hi, last color number should be 255, not 256. White is RGB(255,255,255)

Re: Printout does not match pivot table properties

mbourges — Thu, 07 Mar 2019 21:36:32 GMT

You're right, turns out I'm not consistent and the columns 'Quantity' and 'BOM' had the right color code, not the first few colors.

Unfortunately that's not solving my issue, thank you nonetheless!

Re: Printout does not match pivot table properties

rubenmarin — Fri, 08 Mar 2019 07:43:45 GMT

Can you post a sample that shows the problem? Hope I can take a look later.