topic Expression in Null and Zero Value in App Development

Expression in Null and Zero Value

JIEUNLIM — Wed, 01 Apr 2020 02:24:50 GMT

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.

Re: Expression in Null and Zero Value

ManojKumar14 — Wed, 01 Apr 2020 05:39:03 GMT

Hi Jieunlim,

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

Re: Expression in Null and Zero Value

lorenzoconforti — Wed, 01 Apr 2020 08:11:30 GMT

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

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