topic Re: Select in field blanks in QlikView

Select in field blanks

tinkerz1 — Tue, 08 Sep 2015 10:08:27 GMT

Hi,

When I set up a button with an action for 'Select In Field' and try to find blanks in the search string by using (A|"")

QV will find A but not "", if I use just "", what QV really returns is all greyed out in the Multi box selection so I dont think its selecting blanks its just return nothing selected in that field.(I have other select in fileds triggering the selections)

What is the best way to set up and Or statement using select in field>search string? (A|"") is not the best way.

Should I find blanks in the load statement and put a text or symbol?

Thanks

Re: Select in field blanks

alexandros17 — Tue, 08 Sep 2015 10:10:03 GMT

Yes, if you need to identify blanks then assign them a text

Re: Select in field blanks

sunilkumarqv — Tue, 08 Sep 2015 10:19:51 GMT

you can try in different way

select in field

If(len(Field)=0 or Field='',Field)

Re: Select in field blanks

tinkerz1 — Tue, 08 Sep 2015 11:54:18 GMT

Both answers are correct, Sunil's answer shows how you can adapt an expression to meet a search string.

Select in field

If(len(Field)=0 or Field="",'No String',Field)

Search string

('No String'|A|B)

This is clearer.