Expression in Null and Zero Value

[JIEUNLIM]

I use Qlik sense. 

I want to ask about expressions of Null and Zero Value.

The attached file has a sample data set.
In particular, assets submitted include Null and Zero.

When I add an Excel datasheet, 2000 is null and 2007 is 0 in the asset field. When I upload this data to qlik, it seems to show 0 in both 2000 and 2007.

I want to implement a line chart.
In 2000, there is a way to represent the year, but is there a way to represent it as NULL rather than 0?
I know that in this case, the lines in the chart may be cut off.

Is there a solution?

I attached qvf file. 

[ManojKumar14]

Hi Jieunlim,

I have found a solution to this, refer the attached file below, hope it helps!

[lorenzoconforti · Accepted solution]

Building on @ManojKumar14  answer, to make it generic rather than fix the year:

if(isnull(asset), null(), Sum(asset))