topic Expression result in QlikView https://community.qlik.com/t5/QlikView/Expression-result/m-p/354064#M493400 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>As a result of expression (TextCount function), wherever output is zero, two types of output is appearing in pivot table in QV.</P><P>It is either "0" (zero) or "-" (dash).</P><P>This expression is actually counting errors that are on Name of person.</P><P>What I want is if somebody has not worked on specific process, there should be "-". If no. of errors are zero, then there should be "0".</P><P>Can anybody help me to figure out problem?</P></BODY></HTML> Wed, 16 May 2012 12:52:28 GMT 2012-05-16T12:52:28Z Expression result https://community.qlik.com/t5/QlikView/Expression-result/m-p/354064#M493400 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>As a result of expression (TextCount function), wherever output is zero, two types of output is appearing in pivot table in QV.</P><P>It is either "0" (zero) or "-" (dash).</P><P>This expression is actually counting errors that are on Name of person.</P><P>What I want is if somebody has not worked on specific process, there should be "-". If no. of errors are zero, then there should be "0".</P><P>Can anybody help me to figure out problem?</P></BODY></HTML> Wed, 16 May 2012 12:52:28 GMT https://community.qlik.com/t5/QlikView/Expression-result/m-p/354064#M493400 2012-05-16T12:52:28Z