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 ?
Solved! Go to 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..
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?
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 ?
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..
In AppSheet, comparing any value to "" using = or <> is a bad idea. Use iSBLANK() or ISNOTBLANK() instead.
Thanks !
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |