Strange error with a slices

AppSheet AppSheet Q&A
1

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 ?

2

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?

1 Like
3

Thanks to be back !

Here main data I want to filter :

GaelDuret_0-1646274759558.png
GaelDuret_0-1646274759558.png1000×303 23.5 KB

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 :

GaelDuret_1-1646274869139.png
GaelDuret_1-1646274869139.png2449×1455 122 KB

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

GaelDuret_2-1646274948721.png
GaelDuret_2-1646274948721.png2769×533 38.5 KB

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

Result in the application :

GaelDuret_3-1646275010509.png
GaelDuret_3-1646275010509.png1384×397 21.2 KB

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

Do I miss something ?

4

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..

2 Likes
5

Thanks !

6

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

1 Like