topic Re: Coloring alternate rows in a straight table in QlikView

Coloring alternate rows in a straight table

Tue, 10 Jul 2012 10:31:43 GMT

I have a straight table.

I want the alternate rows to have background color gray and white.

Is there a simple way to achive this?

Re: Coloring alternate rows in a straight table

giakoum — Tue, 10 Jul 2012 10:36:42 GMT

It is in style tab in the chart properties. Stripes every X lines.

Re: Coloring alternate rows in a straight table

Tue, 10 Jul 2012 10:44:33 GMT

Should some associated settings be done?

because I tried setting "Stripes every X lines" to 1 and then to two..but no change.

Do you know where we need to specify the colors for strips?

Re: Coloring alternate rows in a straight table

jonathandienst — Tue, 10 Jul 2012 10:45:10 GMT

The attached file has one example using RowNo() in a background colour expressions, and one using one of the built-in pajama stripe styles.

If you want gray and white stripes, the first method is probably the one you want.

Regards

Jonathan

Re: Coloring alternate rows in a straight table

giakoum — Tue, 10 Jul 2012 10:52:14 GMT

It should automatically work for a straight table. Check out Jonathan's example.

Current style determines the colors, unless you go with rowno where you can set any color you like.

Re: Coloring alternate rows in a straight table

Tue, 10 Jul 2012 12:19:28 GMT

Jonathan,

That helped

Thank you

I used the first method ..that is, in the 'bachground' for both dimension and expressions i gave this

=if(Even(RowNo(TOTAL)), rgb(219,219,219), rgb(255,255,255)) So that the even rows be shown in gray and odd rows be in white.

Thank you once again !

Re: Coloring alternate rows in a straight table

Wed, 24 Jul 2013 12:59:07 GMT

The RowNo() function disbales interactive sort! Any solutions for that?

Thank you!

Re: Coloring alternate rows in a straight table

Thu, 30 Apr 2015 09:37:57 GMT

Hey Abhinav,

In that case, you can create a dummy column with RowNo() function and then hide it. The alternative color will workk fine.

Thanks,

Singh

Re: Coloring alternate rows in a straight table

Anonymous — Thu, 18 Jun 2015 18:37:19 GMT

Hi Jonathan

This works nicely to do a custom pyjama but... it breaks the "Suppress Zero-Values" setting

Any idea why and how to fix this problem ?

The same happens in this other example found here :

Total row in a straight table - Design problem

Thanks

Re: Coloring alternate rows in a straight table

Anonymous — Thu, 18 Jun 2015 21:04:08 GMT

I found the answer here : RowNo() in Background Color in Expression causes zero values to appear?

Re: Coloring alternate rows in a straight table

Dima_qlikview — Wed, 31 Jul 2019 18:37:02 GMT

Jonathan,

Yesterday I downloaded your example and it worked fine. Today when I opened it (and other tables I used this in) the RowNo() method is not working, no-matter what I do. Any ideas? The pre-built Pyjamas are working. I even re-installed Qlik to no avail. Thanks!