This content has been marked as final. Show 4 replies
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.