Button to search empty fields

[#1]

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.

[swuehl]

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

[#3]

That didn't work. Any other thoughts?

[#4]

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 .......

[swuehl]

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

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

or

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.

[#6]

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.

[swuehl]

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