topic Blank filter in QlikView

Blank filter

Mon, 19 Jan 2015 18:24:15 GMT

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)

Re: Blank filter

consenit — Mon, 19 Jan 2015 19:17:43 GMT

Hi there.

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

LOAD

...

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

.....

Kind regards,

Ernesto.

Re: Blank filter

Mon, 19 Jan 2015 19:55:16 GMT

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