# Show N/A Data in Event Report **URL:** \ **Category:** Support - Assistance technique\ **Created:** [5 November 2020 14:01 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205 "2020-11-05T14:01:26Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![HawraaSweidan](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/hawraasweidan/32/47578_2.png) [@HawraaSweidan](https://community.dhis2.org/u/HawraaSweidan)\ **Post date:** [5 November 2020 14:01 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/1 "2020-11-05T14:01:26Z")
Greetings, I have an issue with the Yes / No Data Elements. So, when trying to filter data with No or Blank Values, I can choose only the No value, there’ no way I can show the variables with N/A values. For Instance, I have a data element called duplicate, so in my list I want to retrieve cases that aren’t duplicates and this applies for data elements with No value or even N/A. How can I have a list with these two values. Sincerely, HS ---
**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\ **Post date:** [6 November 2020 07:21 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/2 "2020-11-06T07:21:13Z")
Can you share the screenshot of the problem you are trying to solve, so that we can get some more idea of the problem ---
**Author:** ![HawraaSweidan](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/hawraasweidan/32/47578_2.png) [@HawraaSweidan](https://community.dhis2.org/u/HawraaSweidan)\ **Post date:** [6 November 2020 10:13 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/3 "2020-11-06T10:13:09Z")
This is a screenshot from the event report of the duplicate data element, It only allows me to choose whether the data element value is Yes or No, I want cases that are not duplicates, and this has to be either ‘No’ or ‘N/A’. but I can’ t choose cases with N/A values. ![image](https://dhis2.b-cdn.net/uploads/default/original/3X/d/2/d224a317d97073353de957af35761702eb199705.png) ---
**Author:** ![jesplana](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/j/74df32/32.png) [@jesplana](https://community.dhis2.org/u/jesplana)\ **Post date:** [6 November 2020 11:01 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/4 "2020-11-06T11:01:48Z")
@HawraaSweidan I don’t think you can select it from there but if you leave the selection blank, run the report, it should show you all of the values (Yes, No, N/A). Then you can download it in excel and filter the N/A items. Not sure if others have other solution. One way to overcome this issue is to change your DE to mandatory so you get yes/no answers. John ---
**Author:** ![HawraaSweidan](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/hawraasweidan/32/47578_2.png) [@HawraaSweidan](https://community.dhis2.org/u/HawraaSweidan)\ **Post date:** [6 November 2020 13:58 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/5 "2020-11-06T13:58:10Z")
Thanks for your reply, but the idea is that I want to have it kind of dashboard that shows non-duplicate cases, downloading the excel and then uploading it to the dashboard will take time , and it won’t be automatic. what if we created a program indicators that counts once the value is no or blank, will we be able to retrieve it in the event report as an individual event? ---
**Author:** ![jthomas](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jthomas/32/32752_2.png) [@jthomas](https://community.dhis2.org/u/jthomas)\ **Post date:** [10 November 2020 14:25 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/6 "2020-11-10T14:25:20Z")
Yes your requirement seems to be a good candidate for a program indicator where your filter section should contain something like `#{vY4mlqYfJEH.Va3FC8Io1b0} != 1` or `#{vY4mlqYfJEH.Va3FC8Io1b0} == ''` Assuming code 1 = Yes and 0 = No ---
**Author:** ![HawraaSweidan](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/hawraasweidan/32/47578_2.png) [@HawraaSweidan](https://community.dhis2.org/u/HawraaSweidan)\ **Post date:** [21 November 2020 09:15 UTC](https://community.dhis2.org/t/show-n-a-data-in-event-report/41205/7 "2020-11-21T09:15:12Z")
Thanks @jthomas