Cognos Analytics

Expand all | Collapse all

Exclude Function Removes Null Entries

  • 1.  Exclude Function Removes Null Entries

    Posted Fri July 19, 2019 11:53 AM

    Hi folks,

    I've had a second issue I've come across and that's using the filter quick function to exclude a piece of data. For instance, I search by communities a lot, and often times they could be missing for whatever reason. If I search for a specific area, it's easier to remove everything that doesn't belong rather than trying to include everything that does as I might miss something the latter way. If something is blank, I do further research to see if it's something that applies or does not, and it's important to keep the blanks.

    When using the exclude function however, say for the community of Oakfield, I'll lose out on entries that don't have the field entered where I would manually investigate further. Is there a way to keep the exclude function (as it is incredibly swift and helpful) without removing any null fields in the column?



    ------------------------------
    Devon Connellan
    ------------------------------


  • 2.  RE: Exclude Function Removes Null Entries

    Posted Fri July 19, 2019 12:35 PM
      |   view attached
    @Devon Connellan Continuing with my update on your other post, the new filter dialog in 11.1.3 has the option to include null, empty, and whitespace​

    ------------------------------
    DENNY NAREZNY
    ------------------------------