topic Re: changing dash [-] to zero in QlikView https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156933#M377335 <HTML><HEAD></HEAD><BODY><P>Just a small update to <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ recommendation..</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Alt(YourExpression<SPAN style="text-decoration: underline;">*1</SPAN>, 0)</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P>A numeric filled string will also taken care by this...<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P></BODY></HTML> Fri, 27 May 2016 16:00:31 GMT Saravanan_Desingh 2016-05-27T16:00:31Z changing dash [-] to zero https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156929#M377331 <HTML><HEAD></HEAD><BODY><P>How do I change this calculated [-] to zero?</P><P><IMG alt="1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125947_1.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 27 May 2016 05:39:15 GMT https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156929#M377331 2016-05-27T05:39:15Z Re: changing dash [-] to zero https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156930#M377332 <HTML><HEAD></HEAD><BODY><P><STRONG><EM>= If (isnull(YourExpression),0,YourExpression)</EM></STRONG></P></BODY></HTML> Fri, 27 May 2016 05:43:02 GMT https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156930#M377332 Kushal_Chawda 2016-05-27T05:43:02Z Re: changing dash [-] to zero https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156931#M377333 <HTML><HEAD></HEAD><BODY><P>In presentation tab for missing and null symbol u replace - by zero.</P></BODY></HTML> Fri, 27 May 2016 05:47:50 GMT https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156931#M377333 2016-05-27T05:47:50Z Re: changing dash [-] to zero https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156932#M377334 <HTML><HEAD></HEAD><BODY><P>Or even this should work for true nulls</P><P><STRONG>Alt(YourExpression, 0)</STRONG></P><P></P><P>Incase they are not true nulls, you can try this:</P><P><STRONG>If(Len(Trim(YourExpression)) &gt; 0, YourExpression, 0)</STRONG></P></BODY></HTML> Fri, 27 May 2016 09:20:36 GMT https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156932#M377334 sunny_talwar 2016-05-27T09:20:36Z Re: changing dash [-] to zero https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156933#M377335 <HTML><HEAD></HEAD><BODY><P>Just a small update to <A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌ recommendation..</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Alt(YourExpression<SPAN style="text-decoration: underline;">*1</SPAN>, 0)</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P>A numeric filled string will also taken care by this...<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P></BODY></HTML> Fri, 27 May 2016 16:00:31 GMT https://community.qlik.com/t5/QlikView/changing-dash-to-zero/m-p/1156933#M377335 Saravanan_Desingh 2016-05-27T16:00:31Z