Using showEmptyValues in flat view

Hello, Jimmy,
 
Thank you for your question.
 
Currently, showEmptyValues is intended for compact/classic layouts.
Still, it is possible to filter out empty values by applying the corresponding filter (see Filter Object format).
For example, the following will only show rows where the measure "Discount" is not empty:

{
   uniqueName: "Discount",
   filter: {
     exclude: [
       "discount.[]"
     ]
   }
}

Here is a JSFiddle for illustration: https://jsfiddle.net/flexmonster/efLwkb6s/.
You can also apply filters programmatically with the setFilter() API call.
 
Please let us know if this helps.
 
Kind regards,
Vera

Hello, Jimmy,
 
Thank you for your reply.
 
To filter out empty values in a flat layout, you need to filter each field containing empty values.
Here is a JSFiddle for illustration: https://jsfiddle.net/flexmonster/182vLnso/. In the example, we used different data types such as "date string", "time", "string", and "number".
 
Please let us know if this helps.
 
Kind regards,
Vera

Hello, Jimmy,
 
Thank you for providing a code sample.
 
We noticed that "AccountDescription" doesn't contain any values - they are all empty.
In this case, the exclude filter won't work. 
 
In case you would like to display only the rows where all columns contain values, this is possible by applying a query filter.
For example:

"filter": {
   "query": {
      "not_equal": "(blank)"
   }
}

This will result in an empty grid if there are only empty values in the filtered field.
 
If you are looking for a way to hide empty columns, the best way is to exclude them from the slice. This can be done via Flexmonster's UI through the Field List.
 
We hope this helps!
Feel free to reach out should other questions arise.
 
Kind regards,
Vera

Hello, Jimmy,
 
Thank you for your question.
 
Currently, Flexmonster's UI doesn't support "or" filters.
For such cases, we suggest filtering the data outside of Flexmonster, for example, on your server.
 
Should other questions arise, feel free to reach out.
 
Kind regards,
Vera