Blank filter

[#1]

I have a filter that shows an empty field. Is there any way to make that blank filter disappear? (Theres a number linked to that blank filter, but i don't need to show it, that's why i dont wan't it to appear on my qv)

[consenit · Accepted solution]

Hi there.

I usually filter out null values in my script, something like:

LOAD

     ...

     IF(ISNULL(fieldname), 'NO DATA', fieldname),

     .....

Kind regards,

Ernesto.

[#3]

Perfect! That's the solution, thank you Ernesto!