https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/1529576#M438654 <P>Try to uncheck 'Suppress Zero Values' on the presentation tab of the chart properties.</P> Fri, 11 Jan 2019 16:29:41 GMT sunny_talwar 2019-01-11T16:29:41Z https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/1529572#M438653 <P>Hi,</P><P>I have two tables below:&nbsp;</P><TABLE><TBODY><TR><TD>Group_ID</TD><TD>Group_Name</TD></TR><TR><TD>1</TD><TD>A</TD></TR><TR><TD>2</TD><TD>B</TD></TR><TR><TD>3</TD><TD>C</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>Ticket_Number</TD><TD>Group_ ID</TD></TR><TR><TD>INC123</TD><TD>1</TD></TR><TR><TD>INC456</TD><TD>1</TD></TR><TR><TD>INC789</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>After I load the data and create a table chart with Group Name as dimension and count(ticket_number) as expression, the result is:</P><TABLE><TBODY><TR><TD>Group_Name</TD><TD>Count(Ticket_number)</TD></TR><TR><TD>A</TD><TD>2</TD></TR><TR><TD>B</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>But what I want is:</P><TABLE><TBODY><TR><TD>Group_Name</TD><TD>Count(Ticket_number)</TD></TR><TR><TD>A</TD><TD>2</TD></TR><TR><TD>B</TD><TD>1</TD></TR><TR><TD>C</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could anyone help me how to display this 0?</P> Sat, 16 Nov 2024 21:36:48 GMT https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/1529572#M438653 songzixian2016 2024-11-16T21:36:48Z https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/1529576#M438654 <P>Try to uncheck 'Suppress Zero Values' on the presentation tab of the chart properties.</P> Fri, 11 Jan 2019 16:29:41 GMT https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/1529576#M438654 sunny_talwar 2019-01-11T16:29:41Z https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/2053172#M1223060 <P>In Qliksense there is no such option Could you please tell how to do this in Qliksense since i am also facing a similar issue</P> Sat, 25 Mar 2023 10:17:49 GMT https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/2053172#M1223060 rajeshwar1 2023-03-25T10:17:49Z https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/2053179#M1223061 <P>Hi&nbsp; <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/158851">@rajeshwar1</a>&nbsp;</P> <DIV id="bodyDisplay_0" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Open the chart properties</P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BrunPierre_0-1679745773992.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103494iBB288C469D841F06/image-size/medium?v=v2&amp;px=400" role="button" title="BrunPierre_0-1679745773992.png" alt="BrunPierre_0-1679745773992.png" /></span></DIV> </DIV> Sat, 25 Mar 2023 12:03:28 GMT https://community.qlik.com/t5/QlikView/How-to-display-0-count-in-table/m-p/2053179#M1223061 BrunPierre 2023-03-25T12:03:28Z