2 Replies Latest reply on Dec 2, 2016 8:34 AM by Corey Turner

    Null Literal values in "Custom Value List"

    Corey Turner

      When selecting members for a filter or set, I can't figure out how to include a Null literal value in the "Custom Value List". I'm looking for a way to specifically include the Null literal value only from the custom value list. It seems like tableau will only include "Null" where it evaluates to the textual value. If you select the Null literal value from the "Select from list" menu, and then change to "Custom Value List", it is displayed just like you typed it in yourself and works as expected. For people just using the "Custom Value List" method, I think this could be misleading for a lot of people if they are expecting a null literal to be included.


      Does anybody know of a better way to include the null literal value without selecting it from the list first?


      It would be nice if there was a way to differentiate the null literals, maybe it was colored or something.


      One example of this that I quickly came up with... The below picture has a Null literal and a textual Null, but you can't differentiate them here or in your viz.


        • 1. Re: Null Literal values in "Custom Value List"
          Ashish Chaudhari

          Hi Corey,


          Try using exclude filter instead of using Include in this section. Exclude all the value list except actual Null and Textual Null.


          Can you also discuss the case more? It will help all of us to understand what you are trying to achieve and is there any alternative of doing it then what you are following.. Also mention output that you are expecting.


          Custom value list is used when you have total 1000 values but you get list of 250 values and someone asks to check you if they are available in the data or not. You can directly copy and paste the values to the custom value list. This avoids the manual selection of 250 values in the filter section which might consume lot of time.



          • 2. Re: Null Literal values in "Custom Value List"
            Corey Turner



            Thanks for your time... Switching the filter type to exclude would work in this case to include the null literals, but it doesn't help if the domain of the field is changing. Using "exclude" to include a specific list of values will include extra values if they are new to the data set.


            I work with data source filters a lot (that are dependent on parameters), and using the "select from list" will show members after the data source filter is applied. What if that parameter changes? Then the possible values for the "select from list" changes. This is why I use "custom value list" so I know that I have a very specific list of values included whether they are in the domain or not. Does that make sense?


            I use the copy/paste feature all the time. Love it! I just wish I could paste in a null literal