Hi Everyone,I am trying to Filter my data/table for entries, if two columns are empty. If they are empty I don't want to see them at all (Filter them from all my data).But the Filter (X!='' and Y!='') is not working.

Hi @jonas.venne ,

I think you have to use OR operator instead of AND because AND operator works only if both the conditions are true. OR operator will work if any one of the condition is true.

Hi Jonas

to me it looks like your columns have NULL values, not '' as string values.

When you Filter on those columns, rows with NULL values are automatically excluded.

You may want to try something like the following:

FILTER "reportdataextraction"."resultsqueeze" IS NOT NULL AND "reportdataextraction"."resultvalidation" IS NOT NULL;

This should also work, as the COALESCE accounts for the NULL values:

FILTER COALESCE("reportdataextraction"."resultsqueeze", '') = '' AND COALESCE("reportdataextraction"."resultvalidation", '') = '';

BR Philipp

@jonas.venne 

You can try below,

FILTER TO_STRING ("reportdataextraction"."resultsqueeze") IS NULL OR

TO_STRING ("reportdataextraction"."resultvalidation") IS NULL;