Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Assume 0 if no data point in expression?

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

regards

Darek

4 Replies
Not applicable

Re: Assume 0 if no data point in expression?

what with conditional expression like this:

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

??

Not applicable

Re: Assume 0 if no data point in expression?

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

Re: Assume 0 if no data point in expression?

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

regards

Darek

Not applicable

Re: Assume 0 if no data point in expression?

This works, thanks.

Community Browser