topic Re: Alternate row color +null in QlikView

Alternate row color +null

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have used the below logic to get the alternate colors.But i'm not get the colored null values.

Logic: =if(even(RowNo(TOTAL)),lightgray(),white())

Thanks..

Re: Alternate row color +null

dsharmaqv — Wed, 22 Feb 2017 11:54:35 GMT

try this

Coloring alternate rows in a straight table

Re: Alternate row color +null

marcus_sommer — Wed, 22 Feb 2017 11:55:47 GMT

AFAIK NULL couldn't be colored - therefore you need to replace the NULL's with a real value either within the data or maybe by something like: rangesum(YourExpression, 0) as chart-expression.

- Marcus

Re: Alternate row color +null

avinashelite — Wed, 22 Feb 2017 11:56:31 GMT

Try this

=if(even(RowNo(TOTAL)),lightgray(),if(even(RowNo(TOTAL)) and expression=null(),lightgray(),white()))

Re: Alternate row color +null

nareshthavidishetty — Wed, 22 Feb 2017 12:09:58 GMT

Hi,

It's not working.

Thanks..

Re: Alternate row color +null

sasikanth — Wed, 22 Feb 2017 12:16:44 GMT

Try this

IF(Even(RowNo(TOTAL)) OR Len(Even(RowNo(TOTAL)) )=0,Lightgray(),white())

Re: Alternate row color +null

avinashelite — Wed, 22 Feb 2017 12:22:53 GMT

Then convert the null values to 0 ,

if(len(Trim(Expression))>0,Expression,0)

NOTE:

Replace the Expression with your actual expression

Re: Alternate row color +null

avinashelite — Wed, 22 Feb 2017 12:23:21 GMT

if you are not able to achieve the same, provide the sample app

Re: Alternate row color +null

nareshthavidishetty — Wed, 22 Feb 2017 14:38:29 GMT

Hi,

Still the nulls were not colored.

Thanks..

Re: Alternate row color +null

Anil_Babu_Samineni — Wed, 22 Feb 2017 15:23:43 GMT

Would you provide sample to look, Where this is not working. Even i've dump and i tried it covered to Null values