Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Blank filter value in date filter

Hi guys,

 

i have a date filter that shows a blank filter option for the date range 01.01.2019 - 31.12.2019:

 

But when i change to 02.01.2019 - 31.12.2019 the blank value disappears: 

 

 

The relationship look like this:

 

1) Date table

2) Order table

3) Item table

 

 

Now i don't understand why for 01.02.2019 - 31.12.2019 the date filter shows a blank value but not for 02.01.2019 because if i look at the date table i don't see any blank values for 01.02.2019:

 

Thanks guys!

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    That generally means an unmatched value across a relationship.
    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes it comes through the last relation:

       

       

      when i remove that one the blank field will also disappear. But i don't get how that causes the blank field. How can i fix this?

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous ,

         

        According to the direction of your relationship, you can't remove the blank field.

         

        Best Regards,

        Jay

         

        Community Support Team _ Jay Wang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.