Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
JIEUNLIM
Contributor II
Contributor II

Expression in Null and Zero Value

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. 

1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

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

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

View solution in original post

2 Replies
ManojKumar14
Partner
Partner

Hi Jieunlim,

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

lorenzoconforti
Specialist II
Specialist II

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

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

View solution in original post