Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
nareshthavidishetty
Contributor III

Alternate row color +null

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())

Untitled.png

Thanks..

9 Replies
dsharmaqv
Contributor III

Re: Alternate row color +null

MVP & Luminary
MVP & Luminary

Re: Alternate row color +null

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

Try this

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

nareshthavidishetty
Contributor III

Re: Alternate row color +null

Hi,

It's not working.

Thanks..

sasikanth
Valued Contributor III

Re: Alternate row color +null

Try this

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

Re: Alternate row color +null

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

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

nareshthavidishetty
Contributor III

Re: Alternate row color +null

Hi,

Still the nulls were not colored.

Thanks..

Re: Alternate row color +null

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)