3 Replies Latest reply on Dec 4, 2018 12:20 AM by tian.yang.4

    Set action -- invalid filter

    tian.yang.4
    tian.yang.4 Nov 23, 2018 3:50 AM

      Hello experts,

       

      I'm using the new feature of tableau 2018.3 and here I meet a question.

       

      See the attached workbook.

       

      I create a DATE (SET) from Date (Dimensions) and I put it into filters in Sheet13.

      And then I go to Dashboard--Actions--Set action (source sheets: sheet13 & 13(2), target set: DATE)

       

      And then problem comes, when I select date in sheet 13, it shows errors.

      The worksheet "sheet 13" contains errors. The following will be removed : The field 'DATE' has an invalid filter

       

      The DATE(SET) then with red "!"

       

      Does anyone has similar experience and can offer some help?

       

      THANKS

      YT

      • 179 Views
      • Categories: Actions & Filters
      • Tags:
        • 1. Re: Set action -- invalid filter
          Julien Couffinhal
          Julien Couffinhal Nov 26, 2018 11:04 PM (in response to tian.yang.4)

          Hi YT,

           

          Unfortunately I do not have a solution to this problem either but I have the same issue.

           

          Therefore, I notice that my Set Actions didn't work with "date" as well, I didn't have any problem with string.

           

          I opened a case with Tableau customer support, I will share on this thread if I learn anything.

           

          Cheers,

           

          Julien

          • 2. Re: Set action -- invalid filter
            Julien Couffinhal
            Julien Couffinhal Nov 27, 2018 12:12 AM (in response to tian.yang.4)

            Alright, I found a solution for my case which might help you.

             

            It seems that with your date filters, you might have to put everyone on discreet or everyone in continuous in the sheet which is the source of your Set action...

             

            As soon as I did this, my problem disappeared

             

            Not great because there are some visuals which can only appear with one or another... but it does the job until someone finds something more elegant.

            • 3. Re: Set action -- invalid filter
              tian.yang.4
              tian.yang.4 Dec 4, 2018 12:20 AM (in response to tian.yang.4)

              Hi Julien

               

              Thank you for your suggestions.

               

              Yesterday I figure out why it's happened.

              It is because I directly create set from [DATE]--date and when I do customer date first and it becomes number.

              Then it works.

               

              And I think the key is set can be string, number but no a date.

               

              YT