topic Removing '-' from chart in QlikView https://community.qlik.com/t5/QlikView/Removing-from-chart/m-p/938576#M323883 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I've got a problem with a pie chart.</P><P>My dimension code is: =IF(not(Field1 = 'string'), Field2)</P><P>Expression code is just sum of field: SUM(field)</P><P>Everything works fine, but there's a '-' value, which represents values of (Field1 = 'string') from dimension.</P><P>Is there any way to remove these values from this chart?</P><P><IMG alt="null.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96257_null.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 17 Aug 2015 12:49:17 GMT 2015-08-17T12:49:17Z Removing '-' from chart https://community.qlik.com/t5/QlikView/Removing-from-chart/m-p/938576#M323883 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I've got a problem with a pie chart.</P><P>My dimension code is: =IF(not(Field1 = 'string'), Field2)</P><P>Expression code is just sum of field: SUM(field)</P><P>Everything works fine, but there's a '-' value, which represents values of (Field1 = 'string') from dimension.</P><P>Is there any way to remove these values from this chart?</P><P><IMG alt="null.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96257_null.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 17 Aug 2015 12:49:17 GMT https://community.qlik.com/t5/QlikView/Removing-from-chart/m-p/938576#M323883 2015-08-17T12:49:17Z Re: Removing '-' from chart https://community.qlik.com/t5/QlikView/Removing-from-chart/m-p/938577#M323884 <HTML><HEAD></HEAD><BODY><P>Under dimension tab, tick suppress when value is null for this calculated dimension.</P></BODY></HTML> Mon, 17 Aug 2015 12:51:01 GMT https://community.qlik.com/t5/QlikView/Removing-from-chart/m-p/938577#M323884 MK_QSL 2015-08-17T12:51:01Z