topic Re: Assume 0 if no data point in expression? in QlikView https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636258#M678736 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 16 May 2014 14:20:19 GMT 2014-05-16T14:20:19Z Assume 0 if no data point in expression? https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636256#M678734 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>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.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 16 May 2014 13:15:48 GMT https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636256#M678734 2014-05-16T13:15:48Z Re: Assume 0 if no data point in expression? https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636257#M678735 <HTML><HEAD></HEAD><BODY><P>what with conditional expression like this:</P><P></P><P></P><P>if( IsNull([your expression]),0,[your expression])</P><P></P><P>??</P></BODY></HTML> Fri, 16 May 2014 13:35:26 GMT https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636257#M678735 2014-05-16T13:35:26Z Re: Assume 0 if no data point in expression? https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636258#M678736 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Fri, 16 May 2014 14:20:19 GMT https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636258#M678736 2014-05-16T14:20:19Z Re: Assume 0 if no data point in expression? https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636259#M678737 <HTML><HEAD></HEAD><BODY><P>Try to uncheck "Suppress zero values" on presentation tab.</P><P></P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 16 May 2014 14:23:13 GMT https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636259#M678737 2014-05-16T14:23:13Z Re: Assume 0 if no data point in expression? https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636260#M678738 <HTML><HEAD></HEAD><BODY><P>This works, thanks.</P></BODY></HTML> Fri, 16 May 2014 17:55:53 GMT https://community.qlik.com/t5/QlikView/Assume-0-if-no-data-point-in-expression/m-p/636260#M678738 2014-05-16T17:55:53Z