topic Only Function help in QlikView https://community.qlik.com/t5/QlikView/Only-Function-help/m-p/343853#M126954 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone know if you can do a OR in a Only function? For example I have the following expression</P><P></P><P>=Only({$&lt;[Type]={'Comp'}&gt;} Name)</P><P></P><P>which will only show Names where Type = 'Comp'</P><P></P><P>I want to changed the query so it will show a Type of 'Comp' OR 'Open', I tried the the following but does not seem to work </P><P></P><P>=Only({$&lt;[Type]={'Comp'} OR [Type]={'Open'}&gt;} Name) </P><P></P><P>Has anyone any ideas</P><P></P><P>Thanks </P></BODY></HTML> Thu, 08 Mar 2012 23:11:43 GMT ivandrago 2012-03-08T23:11:43Z Only Function help https://community.qlik.com/t5/QlikView/Only-Function-help/m-p/343853#M126954 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone know if you can do a OR in a Only function? For example I have the following expression</P><P></P><P>=Only({$&lt;[Type]={'Comp'}&gt;} Name)</P><P></P><P>which will only show Names where Type = 'Comp'</P><P></P><P>I want to changed the query so it will show a Type of 'Comp' OR 'Open', I tried the the following but does not seem to work </P><P></P><P>=Only({$&lt;[Type]={'Comp'} OR [Type]={'Open'}&gt;} Name) </P><P></P><P>Has anyone any ideas</P><P></P><P>Thanks </P></BODY></HTML> Thu, 08 Mar 2012 23:11:43 GMT https://community.qlik.com/t5/QlikView/Only-Function-help/m-p/343853#M126954 ivandrago 2012-03-08T23:11:43Z Only Function help https://community.qlik.com/t5/QlikView/Only-Function-help/m-p/343854#M126955 <HTML><HEAD></HEAD><BODY><P>You can list more than one value in the element_list:</P><P></P><P>=Only({$&lt;[Type] = {'Comp','Open'}&gt;} Name)</P></BODY></HTML> Thu, 08 Mar 2012 23:52:22 GMT https://community.qlik.com/t5/QlikView/Only-Function-help/m-p/343854#M126955 swuehl 2012-03-08T23:52:22Z