topic Select in Field -> Search String -> If condition in QlikView

Select in Field -> Search String -> If condition

Thu, 03 Feb 2011 21:13:42 GMT

Is it possible to use if condition in search string of Select in field action? For example, I have Fields named NAME and ADDRESS. NAME has two values in them, [My Name] and [Firend Name]. When I do select in Field action for ADDRESS I want to check in serach string the value of NAME field first and then search.

Select in Field = ADDRESS

Search String = if(NAME = 'My Name', Address1, Address2)

The search string syntax with if statement is not working. Any thoughts?

Select in Field -> Search String -> If condition

Miguel_Angel_Baeyens — Thu, 03 Feb 2011 21:22:54 GMT

Hi,

Try something like the following expression

=If(Name='My Name', '(Address1|Address2)', 'Address3')

Hope this helps

Select in Field -> Search String -> If condition

Thu, 03 Feb 2011 21:31:54 GMT

I tried this already as my search string is exactly like yours and it doesn't work. It selects nothing. I trigger the action on OnSelect of NAME field.

Field Event Trigger -> NAME -> OnSelect

Select in Field -> ADDRESS

Search String =if(NAME = 'My Name', 'Address1', 'Address2')

Select in Field -> Search String -> If condition

Thu, 03 Feb 2011 21:38:16 GMT

OKAY, Never mind its working. I figured there was a Syntax error. Thanks For your help Miguel