Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Change color in a pivot table

Dear all

I have a question how to change color in a pivot table.

This is how the table is looking now.

test1.jpg

  How do I do to change it like this:

test2.jpg

Thanks in advance

Markus

1 Solution

Accepted Solutions
its_anandrjs
Not applicable

Re: Change color in a pivot table

Hi,

See the attached file there i do some changes for Background Color and Text Color like

For Background - if(count([Count of Material number])>1,RGB(255,0,0),RGB(196,255,255))

For Text Color - if(count([Count of Material number])>1,White(),Black())

The above condition is for check it depends on you how you want to display.

Regards,

Anand

7 Replies
its_anandrjs
Not applicable

Re: Change color in a pivot table

Hi,

It depend on your condition you are able to change the color of the Background by following code

in background like

if(Count( if(Your Condition))>=2,RGB(255,0,0),RGB(196,255,255))

Do you have any sample

Regards,

Anand

its_anandrjs
Not applicable

Re: Change color in a pivot table

Hi,

You need to go your Expression and click plus button after that click on button and type code there =if(Count( if(Your Condition))>=2,RGB(255,0,0),RGB(196,255,255)) it is a sample code.

Regards,

Anand

Not applicable

Change color in a pivot table

Hi

I have now uploaded an example,

could you please help me? I didn´t follow you

Thanks

Markus

its_anandrjs
Not applicable

Re: Change color in a pivot table

Hi,

See the attached file there i do some changes for Background Color and Text Color like

For Background - if(count([Count of Material number])>1,RGB(255,0,0),RGB(196,255,255))

For Text Color - if(count([Count of Material number])>1,White(),Black())

The above condition is for check it depends on you how you want to display.

Regards,

Anand

its_anandrjs
Not applicable

Re: Change color in a pivot table

Hi,

It is correct that i suggest you.

Regards,

Anand

Not applicable

Re: Change color in a pivot table

Great! Thanks

how do I do the line border in different colors?

I have a "red-box" in my example

BR Markus

johnw
Not applicable

Change color in a pivot table

MMeijer wrote:

how do I do the line border in different colors?


You don't.  You can change all of them using one of the styles on the style tab, or by going to settings -> user preferences -> design -> checkmark "always show design menu items", then right clicking on a cell, selecting "custom format cell", and fiddling around with the border colors there.  But it won't do what you want it to do because it's not changing that specific cell, but rather rows and columns in the chart.