topic Re: Setting multiple conditions in a field via if statement in QlikView https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439023#M487559 <HTML><HEAD></HEAD><BODY><P>Cheers Gysbert, I knew I was nearly there!!!</P></BODY></HTML> Fri, 15 Feb 2013 10:59:16 GMT 2013-02-15T10:59:16Z Setting multiple conditions in a field via if statement https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439021#M487557 <HTML><HEAD></HEAD><BODY><P>Hi Everyone, </P><P></P><P>Can someone tell me why this isn't working please? I remembered you have to use a pipe, but i think i've got the syntax wrong</P><P></P><P>=if(vUserLevel='Region' AND vUserRegion='Scandinavia',('Denamrk|Norway|Sweden'))</P><P></P><P>This is a Select in Field action behind a button that resets defaults.</P><P></P><P>Kind Regards,</P><P></P><P>Miles</P></BODY></HTML> Fri, 15 Feb 2013 10:27:15 GMT https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439021#M487557 2013-02-15T10:27:15Z Re: Setting multiple conditions in a field via if statement https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439022#M487558 <HTML><HEAD></HEAD><BODY><P>Try =if(vUserLevel='Region' AND vUserRegion='Scandinavia','(Denmark|Norway|Sweden)')</P></BODY></HTML> Fri, 15 Feb 2013 10:49:17 GMT https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439022#M487558 Gysbert_Wassenaar 2013-02-15T10:49:17Z Re: Setting multiple conditions in a field via if statement https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439023#M487559 <HTML><HEAD></HEAD><BODY><P>Cheers Gysbert, I knew I was nearly there!!!</P></BODY></HTML> Fri, 15 Feb 2013 10:59:16 GMT https://community.qlik.com/t5/QlikView/Setting-multiple-conditions-in-a-field-via-if-statement/m-p/439023#M487559 2013-02-15T10:59:16Z