Some data points are excluding from charts even no filters are used!!!

[#1]

Hi Experts,

         It is very strange that some data points are excluded from my chart with no reason since no filter is used. Here is my data. What I wanted to do it to show the percentage of each positive answers by gender. I treat overalleval of 4 and 5 as positive and 1,2,3 as negative. Right now only 4,and 5 show up. Please find my sample Qlikview file in the attachment.

Thanks

Longmatch

UserID	Gender	OverallEval	PositiveNegative
1	Male	1	0
2	Female	2	0
3	Female	1	0
4	Male	4	1
5	Male	4	1
6	Female	5	1
7	Female	3	0
8	Male	3	0
9	Male	4	1
10	Female	5	1
11	Female	2	0
12	Male	3	0
13	Male	2	0
14	Male	5	1
15	Female	5	1
16	Female	5	1
17	Female	4	1
18	Female	4	1
19	Male	5	1
20	Male	4	1

[hic]

You have "Suppress zero" and "Suppress missing" checked on the Presentation tab. As a consequence, the bars you are looking for are not shown since they are zero.

HIC

[swuehl]

Which data points are excluded? If you want to see the dimension values even if the result is zero, deselect 'Suppress zero values' on presentation tab.

What do you expect to see for the percentages?

[#4]

Thank you for the quick response. I unchecked the "Suppress zero" and "Suppress missing" in the Presentation tab, but the results are the same- the data points of 1,2,3 are still missing.

[hic · Accepted solution]

No, they are not missing. They just don't have any positive answers.

HIC

[#6]

Thanks. I just realized this.