https://community.qlik.com/t5/App-Development/Replacing-with-0-in-pivot-table/m-p/1708455#M54353 <P>Hey Abhi,</P><P><SPAN>IF(ISNULL(count(order))='-', 0,count(order))</SPAN></P><P><SPAN>If the order field having multiple null values(-) then count of order produce the count is does not gives the (-) . so automatically it provides the count of order as a output.</SPAN></P><P>So Try this simple if condition,</P><P>=if(Order = '-', 0 , count(Order))&nbsp; // if the order field has - it replace those value with 0 or else give the count of order</P><P>Regards,</P><P>Durga</P> Fri, 05 Jun 2020 05:52:04 GMT Durgadevikumar 2020-06-05T05:52:04Z https://community.qlik.com/t5/App-Development/Replacing-with-0-in-pivot-table/m-p/1708335#M54347 <P>I Used below expression but still it is showing '-'.</P><P><FONT>IF(ISNULL(count(order))='-', 0,count(order))</FONT></P> Thu, 04 Jun 2020 19:41:55 GMT https://community.qlik.com/t5/App-Development/Replacing-with-0-in-pivot-table/m-p/1708335#M54347 Abhi999 2020-06-04T19:41:55Z https://community.qlik.com/t5/App-Development/Replacing-with-0-in-pivot-table/m-p/1708455#M54353 <P>Hey Abhi,</P><P><SPAN>IF(ISNULL(count(order))='-', 0,count(order))</SPAN></P><P><SPAN>If the order field having multiple null values(-) then count of order produce the count is does not gives the (-) . so automatically it provides the count of order as a output.</SPAN></P><P>So Try this simple if condition,</P><P>=if(Order = '-', 0 , count(Order))&nbsp; // if the order field has - it replace those value with 0 or else give the count of order</P><P>Regards,</P><P>Durga</P> Fri, 05 Jun 2020 05:52:04 GMT https://community.qlik.com/t5/App-Development/Replacing-with-0-in-pivot-table/m-p/1708455#M54353 Durgadevikumar 2020-06-05T05:52:04Z