Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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