Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Coloring alternate rows in a straight table

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?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Coloring alternate rows in a straight table

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
10 Replies
Partner
Partner

Re: Coloring alternate rows in a straight table

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

Not applicable

Re: Coloring alternate rows in a straight table

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?

Highlighted
MVP
MVP

Re: Coloring alternate rows in a straight table

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Partner
Partner

Re: Coloring alternate rows in a straight table

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.

Not applicable

Re: Coloring alternate rows in a straight table

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 !

Not applicable

Re: Coloring alternate rows in a straight table

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

Thank you!

Not applicable

Re: Coloring alternate rows in a straight table

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

syltremy
New Contributor III

Re: Coloring alternate rows in a straight table

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

syltremy
New Contributor III

Re: Coloring alternate rows in a straight table