No empty values selection in filter table

[KirstenKa]

It is not possible to select for empty values in the filter in the table, how to resolve this?

[KirstenKa]

Thanks @Zapparoli  this one eventually worked. Reason of not working was probably that the Unqualify function was at the wrong place

[KirstenKa]

Hi @Zapparoli  I have a few issues that occured due to this code. The code to remove empty values in a column no longer works, it doesn't filter out the empty values. This is the code:

("Season Assignment Active Flag Variant(Regional)"<>' ')

trim([MovAv.4200]) & ''<>''

Where Len(Trim([Theme])) > 0

"LP03 Region Total Season Qty" >0)

[KirstenKa]

@Zapparoli  And I have now N/A N/A in my graph. See below the graph and the setup in the graph, there are no formulas on the right side

[Zapparoli]

Hi @KirstenKa It seems that the null values transformed by the NullValue are in your chart.

In this case instead of NullAsValue *; use NullAsValue FieldA,FieldB; this way the function will only treat the fields that you specify, not the other columns.

-Zapparoli

This what th