topic Re: Select in Field action, select no values in QlikView

Select in Field action, select no values

dselgo_eidex — Thu, 06 Jul 2017 16:09:56 GMT

Hello, I have a variable that can either contain a search string or be blank. I have a button that uses the Select in Field action to apply this search string to a field. However, when the search string is empty, the action will select all of the possible values instead of not selecting any. I figure I can do this using a macro, but I'd like to know if it is possible within the list of actions.

Re: Select in Field action, select no values

Anil_Babu_Samineni — Thu, 06 Jul 2017 16:14:58 GMT

How you are define the search string in your action of the object?

Re: Select in Field action, select no values

dselgo_eidex — Thu, 06 Jul 2017 16:30:31 GMT

The search string is set up like ("A"|"B"|"C"). It is stored into a variable, so my action is:

Select in Field

Field

vSearchString

There is a case where vSearchString will equal null, and I don't want any values to be selected, but the action seems to be selecting all of the possible values anyway.

Re: Select in Field action, select no values

sunny_talwar — Thu, 06 Jul 2017 16:33:27 GMT

Would you be able to share a sample to check out the issue?

Re: Select in Field action, select no values

dselgo_eidex — Thu, 06 Jul 2017 16:45:09 GMT

Actually, I figured out my issue. When my search string was supposed to be NULL, it was actually (""). This caused the Select in Field to select all values which matched that search string, which was every possible value. I adjusted the search string to actually be set to NULL and it now works fine.

Sorry, should've waited a bit before posting this question.

Re: Select in Field action, select no values

antoniotiman — Thu, 06 Jul 2017 16:45:11 GMT

Hi Danny,

try this :

Select in Field -> Field :

=If(Len(Trim(vSearchString)) > 0,'Your Field')

Regards,

Antonio

Re: Select in Field action, select no values

Anil_Babu_Samineni — Thu, 06 Jul 2017 16:48:04 GMT

You can use like below ("A"|"B"|"C"|"")

Re: Select in Field action, select no values

sunny_talwar — Fri, 07 Jul 2017 00:59:50 GMT

Please mark your own response as correct to close this thread.

Best,

Sunny