Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nazaninslp
Contributor III
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

2 Replies
rick_hoorn
Contributor
Contributor

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
Partner - Creator
Partner - Creator

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

Refer the help page.

You Know What To Do.