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: 
Not applicable

Assume 0 if no data point in expression?

Hi everyone,

I'm currently working on a line graph containing several expressions. I have months plotted on the x axis and a calculated percentage on the y axis. For some of these months there is no data after drilling down on it, and by default qlikview doesn't display those months on the chart. Since I am interested in data trends, it doesn't make sense to have a jump in months. For example, if I have no data (given the current selection) for April 2013 and May 2013 the chart goes from March 2013 to June 2013. Is there a way in qlikview to assume that if there's no data available for a certain coordinate on a chart that it is 0? This way the graph appears more accurate for data analysis.

Thank you.

1 Solution

Accepted Solutions
Not applicable
Author

Try to uncheck "Suppress zero values" on presentation tab.

regards

Darek

View solution in original post

4 Replies
Not applicable
Author

what with conditional expression like this:

if( IsNull([your expression]),0,[your expression])

??

Not applicable
Author

This works if you put in a very small number, but not zero. I used .00001 and since I'm only displaying 2 decimal places it works. I guess Qlikview doesn't like displaying 0 in a chart.

Not applicable
Author

Try to uncheck "Suppress zero values" on presentation tab.

regards

Darek

Not applicable
Author

This works, thanks.