topic Re: Issues in Pivot alternate colors in QlikView

Issues in Pivot alternate colors

Mon, 17 Feb 2014 15:34:13 GMT

Hi All,

I am facing a lot of difficulties in getting alternating row colors to work on Pivot tables. I am able to get alternating row colors in straight tables either by selecting one of the styles, like Pyjama Green etc. or I can also write this code (if(Even(RowNo()),White(), Green())) and it works good.

But the problem is with Pivot tables. It does not work correctly. Can someone help here please. I have attached a sample file.

Please help!

Thanks

Raghu

Re: Issues in Pivot alternate colors

giakoum — Mon, 17 Feb 2014 15:41:18 GMT

it does work if you put it in the expression background color. But maybe it is because of the sample values. Have you tried it with full values?

Re: Issues in Pivot alternate colors

Anonymous — Mon, 17 Feb 2014 15:43:29 GMT

Here is an idea to try. Use this color expression in each expression and dimension. You may need to adjust your color pallet

color(mod(RowNo(),2)+1)

Re: Issues in Pivot alternate colors

Nagaraju_KCS — Mon, 17 Feb 2014 15:43:48 GMT

Hi Jagan,

Use this expression as Background color expression for all Expressions and Dimensions.

=If(Even(RowNo(TOTAL)), RGB(120,120,120), RGB(100,100,100))

PFA,

Hope this helps you.

----Raju

Re: Issues in Pivot alternate colors

juleshartley — Mon, 17 Feb 2014 15:45:14 GMT

=IF(Even(rowNo(TOTAL)),LightGray(),White())

works as an expression background. I can't get it to work for the dimensions though...

Re: Issues in Pivot alternate colors

giakoum — Mon, 17 Feb 2014 15:52:02 GMT

it is because dimension rows and expression rows are continuous numbers.

if the 1st row is a dimension it is 2, the 2nd being an expression is 2 etc.