topic Re: Button to search empty fields in QlikView

Button to search empty fields

Thu, 14 Jun 2012 14:01:16 GMT

Is there a way to have a button display all the fields that are empty in a given column? I can pick them in Qlikview, so they must have a space of some sort.

Any ideas?

I tried putting = * in the search string but it wont search a space.

Re: Button to search empty fields

swuehl — Thu, 14 Jun 2012 14:15:16 GMT

Try something like this in the search string of your button select - select in field action:

='= not len(trim(FIELDNAME))'

and put FIELDNAME of course also in the entry box of the action dialog.

Hope this helps,

Stefan

Re: Button to search empty fields

Thu, 14 Jun 2012 14:32:55 GMT

That didn't work. Any other thoughts?

Re: Button to search empty fields

Thu, 14 Jun 2012 14:37:27 GMT

I would edit your load script and use if(isnull([FIELDNAME]),'BLANK',[FIELDNAME])

i.e.

LOAD XYZ,

if(isnull(XYZ),'BLANK',XYZ) AS XYZNEW,

FROM .......

Re: Button to search empty fields

swuehl — Thu, 14 Jun 2012 14:44:53 GMT

isnull() will not return true if the field contain some sort of spaces. You need to use

if( len(trim(FIELD))=0, ..

if( len(trim(purgechar(FIELD, chr(160)))) = 0,...

instead.

ethanjbeau, could you upload a small sample file? I assumed your column is a field (e.g. displayed in a list box), not a column in a table that was calculated by an expression.

Re: Button to search empty fields

Thu, 14 Jun 2012 17:47:59 GMT

yes the column is a field. I ended up coping one of the "blank" cells and pasting it and the button works correctly. Now I need to also have it search for nulls and im not sure how to do that.

Re: Button to search empty fields

swuehl — Thu, 14 Jun 2012 18:16:49 GMT

Using one of the methods above to create a new field in the script to flag BLANK / NULL should do what you want.