topic Re: Change color of pivot table expression line in QlikView

Change color of pivot table expression line

Thu, 10 Jul 2014 10:25:23 GMT

Hi @all,

is it possible to change the color of a pivot table expression row line?

It seems that only the colors of the expressions column lines can be changed.

When I change the style of the table, I only get black or light grey, but I need to adjust it to custom colors...

Thanks in advance,

EVa

Re: Change color of pivot table expression line

Thu, 10 Jul 2014 10:29:35 GMT

Hi, Eva.

You can see this link: Traffic light gauge .

The solution of this link is the same like your problem.

Re: Change color of pivot table expression line

VishalWaghole — Thu, 10 Jul 2014 10:31:56 GMT

Hello Eva,

go to setting -> user preference - Design and click always show design menu items

this will enable yuor "Custom format Cell" property.

then right click on pivot table, you will find their "Custom format Cell" property.

-- Regards,

Vishal Waghole

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 07:20:39 GMT

Hi Venelin,

thanks for your reply, but I do not need to show traffic lights, the screenshot is just an example. What I need is to color the row lines of the expressions of the pivot table... As you can see in the screenshot, they are in a light grey, but I need to adjust it to a dark grey according to dimension rows.

Any ideas on this?

Thanks,

Eva

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 07:22:22 GMT

Hi Vishal,

thanks for your help, but I already checked this... I can change the settings of the cells, but it has no affect on the row lines, just on the column lines of the expressions 😕

Do you know if it is even possible to change the row line color?

Regards,

Eva

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 07:35:58 GMT

Hi,

I did a workaround for this, as I cant find an option to set the exact color for the row lines in pivot table.

When I set the table style to "Basic", every row line turns black. Then I change the transparency of the cell borders and it looks like grey in all lines.

Regards,

Eva

Re: Change color of pivot table expression line

aveeeeeee7en — Fri, 11 Jul 2014 07:36:34 GMT

Hi Eva

You can do this using Custom Format Cell.

See the Attachment.

Regards

Aviral Nag

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 07:37:03 GMT

Hi,

I know that, you don't need to show traffic lights, but there similar posts like for your problem.

I think that in this case, the easiest solution is to use tab "Visual Cues" in Chart Properties.

There you can put colours and backgrounds in your tables.

It's useful when you create straight and pivot tables.

In the link which I sent you yesterday, you can see how to fixed you problem.

This is for expression part.

For the dimension part, you can see in the pic, how to change the colour.

Regards,

Venelin

Re: Change color of pivot table expression line

aveeeeeee7en — Fri, 11 Jul 2014 07:41:45 GMT

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 07:48:36 GMT

Thanks Nag, but this didn't work in my pivot table 😞 it seems possible just for dimension rows.

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 07:50:02 GMT

Hi Venelin,

thank you, you are right, when changing cell colors it can be helpful to adjust this via "Visual Cues"! But I didn't find an option on how set the cell border color here...

Regards,

Eva

Re: Change color of pivot table expression line

aveeeeeee7en — Fri, 11 Jul 2014 07:50:42 GMT

What you want.

Attach a Snapshot.

Re: Re: Change color of pivot table expression line

aveeeeeee7en — Fri, 11 Jul 2014 07:58:54 GMT

You can do it by using Line/Arrow Objects.

It's a workaround.

See the Attachment. Hope that works for you.

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 08:00:38 GMT

My first post on this contains a snapshot. I need to color the horizontal row lines of expressions cells in a pivot table.

Re: Change color of pivot table expression line

Fri, 11 Jul 2014 08:04:07 GMT

Hi, Eva.

That's true. I hope to find solution for your problem .

Re: Re: Change color of pivot table expression line

aveeeeeee7en — Fri, 11 Jul 2014 08:07:23 GMT

OK.

See the Attachment.

Re: Change color of pivot table expression line

Anonymous — Thu, 28 May 2015 15:39:59 GMT

Hi,

Took me some time figure it out. PART of the horizontal lines color can be customized use "Custom Format Cell", when "Show Partial Sums" is selected (property->Presentation tab->Dimensions and Expressions).

When you have the "sub total" (default label name "total") in the pivot table, and you MUST right click to open the "Custom Format Cell" when you mouse on the "sub total" row. Then the line color of the horizontal line can be customized, but notice that ONLY the line color of the subtotal row can be changed, NOT the horizontal line color of rows between.

Zhihong