This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Filter Slice Not Correctly Filtering

Posted on 02-23-2022 07:24 AM
mschaef8
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Greetings! I am attempting to implement a filter for a slice of data in my app. I want to create a slice of the "2021" tab for the Date column (Yesterday), Truck/FOB column (FOB), and the Picked Up column (Not "Yes"). 

It gets set up correctly as far as I can tell (screenshot posted below) and this also worked properly several weeks ago before I set the app aside for a time. But when viewing data, the view is empty. Now, viewing the "Test", it evaluates them to false despite them seeming to meet filter conditions. This screenshot is also posted. 

Thank you in advance to any wise AppSheet users out there!

Mike

mschaef8_1-1645629571486.png

mschaef8_2-1645629746409.png

 

 

 

0 1 122
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Joseph_Seddik
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

The test shows: 

  • [Truck/FOB] = FOB --> TRUE
  • [Picked Up] = "Yes" --> not shown in your photo
  • [DATE] = TODAY() --> FALSE

So at least you should have to check this date part which is at least the one evaluating to false. Is your [DATE] column set correctly to type Date? Would you please show your table's configuration?

0 Likes