topic Removing '-' from the output! in QlikView https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306829#M1192763 <HTML><HEAD></HEAD><BODY><P>Dear al,</P><P>I have a simple query(though I' am not getting it right)...I have a table in which there are certain fields where in some cases their respective attributes are apparing as '-'&nbsp; (hyphen)</P><P>Now in that way my count of policy is appearing more than it is in actual, as I' am writing count(distinct Pol_ID)</P><P>i have tried there various options like...suppress where the value is null etc etc.. but it's not working</P><P>kindly help out</P></BODY></HTML> Tue, 21 Jun 2011 13:04:15 GMT gauravkhare 2011-06-21T13:04:15Z Removing '-' from the output! https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306829#M1192763 <HTML><HEAD></HEAD><BODY><P>Dear al,</P><P>I have a simple query(though I' am not getting it right)...I have a table in which there are certain fields where in some cases their respective attributes are apparing as '-'&nbsp; (hyphen)</P><P>Now in that way my count of policy is appearing more than it is in actual, as I' am writing count(distinct Pol_ID)</P><P>i have tried there various options like...suppress where the value is null etc etc.. but it's not working</P><P>kindly help out</P></BODY></HTML> Tue, 21 Jun 2011 13:04:15 GMT https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306829#M1192763 gauravkhare 2011-06-21T13:04:15Z Removing '-' from the output! https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306830#M1192764 <HTML><HEAD></HEAD><BODY><P>In Chart properties, the Presentation tab, Lower left corner there are two fields: NULL SYmbol and Missing Symbol. Clear out the - in there. </P><P></P><P>hth Jeroen</P></BODY></HTML> Tue, 21 Jun 2011 13:29:08 GMT https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306830#M1192764 2011-06-21T13:29:08Z Re: Removing '-' from the output! https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306831#M1192765 <HTML><HEAD></HEAD><BODY><P>Is it possible for you to share the document?</P><P></P><P>Arun</P></BODY></HTML> Tue, 21 Jun 2011 13:31:39 GMT https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306831#M1192765 2011-06-21T13:31:39Z Removing '-' from the output! https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306832#M1192766 <HTML><HEAD></HEAD><BODY><P>I m done with it...thanks</P></BODY></HTML> Wed, 22 Jun 2011 05:51:38 GMT https://community.qlik.com/t5/QlikView/Removing-from-the-output/m-p/306832#M1192766 gauravkhare 2011-06-22T05:51:38Z