topic Re: Background Color Pivot chart (if one dimension on top) in QlikView

Background Color Pivot chart (if one dimension on top)

richters — Fri, 28 Aug 2015 13:22:56 GMT

Hi all,

I created a pivot chart and want to highlight every second row. So I gave every formula and dimension a background formula as followed:

=if(mod(rowno(),2)=0,LightGray(80))

Is it possible to give the cells in red a background color?

Thanks a lot!

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 14:32:55 GMT

Anyone got an idea?

Re: Background Color Pivot chart (if one dimension on top)

sunny_talwar — Mon, 31 Aug 2015 14:39:17 GMT

Have you made sure to use the same expression on your second dimension (Zuverlegung) also?

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 14:41:47 GMT

Yes, everywhere the same expression. Are you able to create a simple pivot chart where one dimension is on top and to set a backgroundcolor like this?

Re: Background Color Pivot chart (if one dimension on top)

sunny_talwar — Mon, 31 Aug 2015 14:43:10 GMT

I will give it a try now. Give me few minutes

Re: Background Color Pivot chart (if one dimension on top)

sunny_talwar — Mon, 31 Aug 2015 14:56:01 GMT

I am unable to replicate the sample image you have shown or I should it say, it would take some effort to create what you have. Would you be able to share a sample to test it out?

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 14:57:32 GMT

Is this what you wanted?

see attached.

make sure your values in cells are not nulls.

If you have any nulls, you cannot see the color in that cell(i anticipate.)

Re: Background Color Pivot chart (if one dimension on top)

sunny_talwar — Mon, 31 Aug 2015 14:59:13 GMT

Need color on the dimension also (not just the expression)

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 15:00:08 GMT

Here you are

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 15:01:05 GMT

No, I want to color the complete row (my problem in your case are the cells under the "C". see attached

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 15:10:24 GMT

The dimension C was pivoted earlier.

See now.

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 15:11:01 GMT

make sure your values in cells are not nulls.

If you have any nulls, you cannot see the color in that cell(i anticipate.)

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 15:12:18 GMT

Look at my example, I got a dimension on top and want to color the complete row. My problem are the cells of the dimension which is on the top.

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 15:18:40 GMT

thats what i said.

When you pivot the dimension, you cannot use rowno().

just specify the background color or text color with no condition on rowno().

See attached

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 15:21:40 GMT

and how do I set the background color of the desired fields (every second row) then?

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 15:24:40 GMT

If i am not wrong, they are already been colored with lightgray.

just replace the lightgrya() with red() everywhere then you can see red.

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 15:29:03 GMT

I want to highlight the following fields in the table (see attached).

I can not see in any example how to color them.

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 15:29:35 GMT

IS this what you wanted?

see attached.

Re: Background Color Pivot chart (if one dimension on top)

Qrishna — Mon, 31 Aug 2015 15:31:31 GMT

those are not field values.

as you have pivoted the dimension, its just an empty column.

Re: Background Color Pivot chart (if one dimension on top)

richters — Mon, 31 Aug 2015 15:32:06 GMT

No, I totally know how to change the color. But in the first red row (Station=B) - the second column (under the dimension title of the second dimension) the field is not red. I want it to be red.