topic Issue with Dial not displaying zero in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Dial-not-displaying-zero/m-p/234361#M85795 <HTML><HEAD></HEAD><BODY><H3>Dear All,</H3><P>I have set up a simple Dial - with no Dimension, just a simple (ish...) expression;</P><P></P><P></P><P>=</P><P><B>Count</B> ({&lt;<B>leadDescShort</B>={'PRM'}&gt;}<B>leadSoldVehicleID</B>)/<B>Count</B> ({&lt;<B>leadDescShort</B>={'PRM'}&gt;}<B>leadContactID)</B></P><P>This divides Sales/Contacts to look at success of marketing activity</P><P></P><P>However, if I have Zero sales in this set - the Dial displays netiher a Needle, nor a value of Zero in the Text in Chart</P><BR /><BR /> <BR /><BR /> <BR /><BR /> <P>I'd like to display a Needle and Text at Zero if the expression cannot be calculated, due to the Numerator being zero</P><P>Many thanks</P></BODY></HTML> Tue, 01 Mar 2011 14:51:29 GMT 2011-03-01T14:51:29Z Issue with Dial not displaying zero https://community.qlik.com/t5/QlikView/Issue-with-Dial-not-displaying-zero/m-p/234361#M85795 <HTML><HEAD></HEAD><BODY><H3>Dear All,</H3><P>I have set up a simple Dial - with no Dimension, just a simple (ish...) expression;</P><P></P><P></P><P>=</P><P><B>Count</B> ({&lt;<B>leadDescShort</B>={'PRM'}&gt;}<B>leadSoldVehicleID</B>)/<B>Count</B> ({&lt;<B>leadDescShort</B>={'PRM'}&gt;}<B>leadContactID)</B></P><P>This divides Sales/Contacts to look at success of marketing activity</P><P></P><P>However, if I have Zero sales in this set - the Dial displays netiher a Needle, nor a value of Zero in the Text in Chart</P><BR /><BR /> <BR /><BR /> <BR /><BR /> <P>I'd like to display a Needle and Text at Zero if the expression cannot be calculated, due to the Numerator being zero</P><P>Many thanks</P></BODY></HTML> Tue, 01 Mar 2011 14:51:29 GMT https://community.qlik.com/t5/QlikView/Issue-with-Dial-not-displaying-zero/m-p/234361#M85795 2011-03-01T14:51:29Z