topic Re: Coloring Rows in QlikView

Coloring Rows

Mon, 01 Dec 2014 17:06:12 GMT

Hello Everybody,

I have a table box as below

Company	division	EmpName	Salary
Comp1	div1	X	15000
Comp2	div2	Y	16000
Comp3	div3	Z	17000
Comp4	div4	P	18000

Now I want the rows should be colored alternatively.

For Ex Row1 = Blue, Row 2 = Green

Row 3 = Blue, Row 4 = Green

Please advise.

Thanks in Advance

Sonali Singh

Re: Coloring Rows

JonnyPoole — Mon, 01 Dec 2014 17:13:13 GMT

Try this as the cell background color.

if ( mod( RowNo( total ) , 2 ) = 1, lightblue(), lightgreen())

Use other color functions like rgb() to get better colors

Re: Coloring Rows

Mon, 01 Dec 2014 22:26:03 GMT

Alternatively, you can go into User Settings >> Design Tab >> select Advanced under the default styling mode >> close out of that and right click on one of the cells >> select Custom Format Cell >> Play around there -- not sure if there is an 'every other row' function, but you can set background color.

It is generally held as best practice for colors to only be used to call attention to certain important data. The layout tab on chart properties should be sufficient to differentiate between adjacent rows in a table. Save color definitions to represent important data and positive/negative KPIs.

Re: Coloring Rows

Tue, 02 Dec 2014 10:34:52 GMT

Hi Jonathan,

Thanks for reply. It is working but my requirement is something different.

Submission ID	Trans ID	Amount
2	E	300
3	A	500
3	B	1050
5	C	39
7	C	400
7	D	350

Now what I want is

If Submission ID "2" is given blue then 3 should "yellow" then again 5 should be blue and 7 should be yellow.

But my ouput is coming something like this. Please find the attached file.

I am using a Pivot table for this.

Thanks In Advanse

Sonali

Re: Coloring Rows

Tue, 02 Dec 2014 12:47:01 GMT

Sonali, I would use the Format Cell option described in my post with advanced default layout.

Re: Coloring Rows

krishna20 — Tue, 02 Dec 2014 12:48:27 GMT

Hi,

Use Text Format in expanding your Expression .You can change the font color whatever you want to display for the particular row, by using like RGB(250,125,132).

Hope this helps

Regards

Krishna

Re: Re: Coloring Rows

JonnyPoole — Tue, 02 Dec 2014 21:35:46 GMT

In a pivot table the rowno() won't work. Instead you can use rank() to figure out the rows of the higher buckets

For the screenshot below the first expression has this background color

=if( mod(aggr( rank( total Division), Division), 2)=1,yellow(),lightred())

The 2nd (company) goes back to using the rowno()

=if( mod(RowNo(Total),2)=1,yellow(),lightred())