Strange error with a slices

[GaelDuret]

Hi All,

I create a slice with a row filter condition to limit row in a view. When I run the test option from Expression Assistant of this row filter condition, I got 1 row with result Y. This is correct and respect my condition.

Then I build a table view using this slice. This view show 2 records, the good one and another record who should not be part of this view ??

Any idea why I got this error ?

[WillowMobileSys]

We would need to see your filter condition and rows of data being returned.

Also, from the slice itself, there is a "view data" button.  What are your results then?

[GaelDuret]

Thanks to be back !

Here main data I want to filter :

Filter is :

AND(TODAY() >= [Lead Clinician due], [Lead Clinician name] = "", [Lead Clinician due] <> "")

With this filter slice should only display patient Dana.

Result from test button :

This look good, the only record having a test result equal to Y is Dana

View data from the slice, look good, only record is Dana

Result in the application :

Record Test show up ! Should not be here because of the [Lead Clinician due] <> "" condition ?

Do I miss something ?

[TeeSee1 · Accepted solution]

Since I saw nothing wrong with what you did, I ran a quick test myself.

Turns out for a DATE column, you should use ISNOTBLANK rather than <> ""

I think this is a bug..

[Steve]

In AppSheet, comparing any value to "" using = or <> is a bad idea. Use iSBLANK() or ISNOTBLANK() instead.

[GaelDuret]

Thanks !