Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Select in field blanks

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

1 Solution

Accepted Solutions
tinkerz1
Creator II
Creator II
Author

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.

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

sunilkumarqv
Specialist II
Specialist II

you can try in different way

select in field

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

tinkerz1
Creator II
Creator II
Author

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.