Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

RowNo() in Background Color in Expression causes zero values to appear?

Hi All

My requirement was to alternately strip rows but only for specific columns in a straight table, so I can delineate particular columns from others but retain the stripe effect.

I used the expression:

=If(Even(RowNo(TOTAL)), rgb(220,220,220), rgb(238,233,233))

This works sort of but with the problem that all values including zero values now show for that expression even though I have suppress zero values ticked?

Can anyone advise why and how I might fix this?

Thanks

Dominic

3 Replies
Not applicable

Re: RowNo() in Background Color in Expression causes zero values to appear?

Please can anyone help?

Thanks

Re: RowNo() in Background Color in Expression causes zero values to appear?

You can enable striping on the Style tab and custom format the cell background colors. Or you can use a calculated dimension. See attached example.

For the custom formatting you need to enable the option Always Show Design Menu Items on the Design tab of the user properties window. With this enabled you can right click a cell and choose Custom Format Cell.


talk is cheap, supply exceeds demand
kumarnatarajan
Valued Contributor

Re: RowNo() in Background Color in Expression causes zero values to appear?

Hi,

You can able to use this condition in dimention field bg area. see the below screenshort

else.

Use Gysbert Wassenaar  way.

Community Browser