Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nazaninegogo
New Contributor III

change NULL function to Zero in qlikview chart expression

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

 

chart.PNG

Tags (1)
2 Replies
rick_hoorn
New Contributor

Re: change NULL function to Zero in qlikview chart expression

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)

 

 

Partner
Partner

Re: change NULL function to Zero in qlikview chart expression

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

Refer the help page.

You Know What To Do.