How to display 0 count in table?

[songzixian2016]

Hi,

I have two tables below: 

Group_ID	Group_Name
1	A
2	B
3	C

Ticket_Number	Group_ ID
INC123	1
INC456	1
INC789	2

After I load the data and create a table chart with Group Name as dimension and count(ticket_number) as expression, the result is:

Group_Name	Count(Ticket_number)
A	2
B	1

But what I want is:

Group_Name	Count(Ticket_number)
A	2
B	1
C	0

Could anyone help me how to display this 0?

[sunny_talwar · Accepted solution]

Try to uncheck 'Suppress Zero Values' on the presentation tab of the chart properties.

[rajeshwar1]

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

[BrunPierre]

Hi  @rajeshwar1 

Open the chart properties

[BrunPierre]

Open the chart properties