change NULL function to Zero in qlikview chart expression

[nazaninslp]

Dears

I have table that sometime some fields  get NULL Value.

I want that NULL values change to zero and my chart doesn't get Error like following pic.

I have tried IsNull Function but didn't work,

would you please help me?

Dimension: DATE

Expression: =if(IsNull(sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}TotalDownload))=0,0,sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}TotalDownload))

[rick_hoorn]

Use the function ALT it can replace any NULL value with 0 (zero):

ALT(sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}TotalDownload),0)

[Vengatesh]

Isnull function gives -1 if there is null value otherwise 0.

Refer the help page.