Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

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

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

UserIDGenderOverallEvalPositiveNegative
1Male10
2Female20
3Female10
4Male41
5Male41
6Female51
7Female30
8Male30
9Male41
10Female51
11Female20
12Male30
13Male20
14Male51
15Female51
16Female51
17Female41
18Female41
19Male51
20Male41
Tags (3)
1 Solution

Accepted Solutions

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

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

HIC

View solution in original post

5 Replies

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

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

MVP
MVP

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

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?

Not applicable

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


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!!!

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

HIC

View solution in original post

Not applicable

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

Thanks. I just realized this.