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

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

Fri, 07 Jun 2013 10:15:19 GMT

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

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

Mon, 10 Jun 2013 07:32:21 GMT

Please can anyone help?

Thanks

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

Gysbert_Wassenaar — Mon, 10 Jun 2013 07:52:40 GMT

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.

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

kumarnatarajan — Mon, 10 Jun 2013 08:19:58 GMT

Hi,

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

else.

Use Gysbert Wassenaar way.