topic change NULL function to Zero in qlikview chart expression in QlikView

change NULL function to Zero in qlikview chart expression

nazaninslp — Wed, 17 Apr 2019 05:22:05 GMT

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

Re: change NULL function to Zero in qlikview chart expression

rick_hoorn — Thu, 25 Apr 2019 07:17:15 GMT

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)

Re: change NULL function to Zero in qlikview chart expression

Vengatesh — Thu, 25 Apr 2019 09:03:20 GMT

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

Refer the help page.