Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
songzixian2016
Not applicable

How to display 0 count in table?

Hi,

I have two tables below: 

Group_IDGroup_Name
1A
2B
3C

 

Ticket_NumberGroup_ ID
INC1231
INC4561
INC7892

 

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_NameCount(Ticket_number)
A2
B1

 

But what I want is:

Group_NameCount(Ticket_number)
A2
B1
C0

 

Could anyone help me how to display this 0?

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: How to display 0 count in table?

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

1 Reply
sunny_talwar
Not applicable

Re: How to display 0 count in table?

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