4 Replies Latest reply: May 16, 2014 1:55 PM by Matt Maino RSS

    Assume 0 if no data point in expression?

    Matt Maino

      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.