topic Re: Some data points are excluding from charts even no filters are used!!! in QlikView

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

Sun, 06 Jul 2014 15:43:06 GMT

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

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

hic — Sun, 06 Jul 2014 16:07:27 GMT

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

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

swuehl — Sun, 06 Jul 2014 16:10:19 GMT

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?

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

Sun, 06 Jul 2014 16:18:21 GMT

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.

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

hic — Sun, 06 Jul 2014 16:32:54 GMT

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

HIC

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

Sun, 06 Jul 2014 16:35:15 GMT

Thanks. I just realized this.