topic Re: Highlight a row in a pivot table chart in QlikView

Highlight a row in a pivot table chart

Mon, 16 Mar 2015 10:44:03 GMT

Dear Experts,

Is there a way to highlight a row in a pivot table chart so it will be easier to read the data?

Thank You

Re: Highlight a row in a pivot table chart

Gysbert_Wassenaar — Mon, 16 Mar 2015 10:47:20 GMT

Yes, click on the + sign in front of the expression on the Expressions tab. Select Background Color and enter an expression to calculate the color. For example =if( ...some...condition..., lightgreen(), lightred()). Do the same as for the dimensions on the Dimensions tab.

Re: Highlight a row in a pivot table chart

sunny_talwar — Mon, 16 Mar 2015 10:50:42 GMT

You can use the following if statement under the Background Color expression

=If(Mod(RowNo(), 2) = 0, RGB(159,159,159))

Output:

HTH

Best,

Re: Highlight a row in a pivot table chart

Mon, 16 Mar 2015 10:53:47 GMT

Thank you for your replies but what I mean is the user if he can highlight when reading a report like in excel if we click on the row number it highlights. Just to know which row the user is reading.

Re: Highlight a row in a pivot table chart

sunny_talwar — Mon, 16 Mar 2015 10:56:19 GMT

That is something I don't know and would love to know if it is possible. I will let gwassenaar answer you on this.

Best,

Re: Highlight a row in a pivot table chart

awhitfield — Mon, 16 Mar 2015 11:22:15 GMT

Could the user not simply click on 'b' ?

Re: Highlight a row in a pivot table chart

Mon, 16 Mar 2015 11:24:35 GMT

What will happen when the user click "b"?

What is "b"/

Re: Highlight a row in a pivot table chart

awhitfield — Mon, 16 Mar 2015 11:27:05 GMT

See the example screen shot from the earlier post..

Re: Highlight a row in a pivot table chart

Mon, 16 Mar 2015 11:29:13 GMT

Can you please explain the formula:

=If(Mod(RowNo(), 2) = 0, RGB(159,159,159))

Re: Highlight a row in a pivot table chart

Mon, 16 Mar 2015 11:30:01 GMT

I did not understand the formula =If(Mod(RowNo(), 2) = 0, RGB(159,159,159)) and how to use it.

Re: Highlight a row in a pivot table chart

sunny_talwar — Mon, 16 Mar 2015 12:12:03 GMT

This formula is just highlighting the Even rows in the Pivot table:

Mod(RowNo(), 2) just means Modulo(RowNo/2). So when we are on RowNo 1 the remainder will be 1 because Modulo(1/2) = 1, where as for every even number remainder will be 0.

So this formula =If(Mod(RowNo(), 2) = 0, RGB(159,159,159)) is just highlighting the even rows in the color grey.

HTH

Best,