topic lookup function not recognized in QlikView https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233528#M85065 <HTML><HEAD></HEAD><BODY><P>my problem is i have a set or data like , how do i write an expression for</P><P>1. All IDs without ProfID,</P><P>2. All ProfIDs without InvID</P><P></P><TABLE><TBODY><TR><TD>ID</TD><TD>profID</TD><TD>InvID</TD><TD>DocType</TD></TR><TR><TD>1</TD><TD>null</TD><TD>null</TD><TD>enq</TD></TR><TR><TD>1</TD><TD>1</TD><TD>null</TD><TD>prof</TD></TR><TR><TD>1</TD><TD>2</TD><TD>null</TD><TD>prof</TD></TR><TR><TD>1</TD><TD>null</TD><TD>2</TD><TD>inv</TD></TR><TR><TD>3</TD><TD>null</TD><TD>null</TD><TD>enq</TD></TR><TR><TD>4</TD><TD>null</TD><TD>null</TD><TD>enq</TD></TR><TR><TD>4</TD><TD>3</TD><TD>null</TD><TD>prof</TD></TR></TBODY></TABLE><P></P><P></P><P>Regards,</P></BODY></HTML> Fri, 07 May 2010 10:06:40 GMT 2010-05-07T10:06:40Z lookup function not recognized https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233523#M85060 <HTML><HEAD></HEAD><BODY><P>im trying to use the lookup function in qlikview like 'lookup('Price', 'ProductID', InvoicedProd, 'pricelist')' ,<BR />but it keeps giving an error message," Error in Expression". Im using version 8.2. does anyone know whats causing this.</P><P>Regards</P><P></P><P></P></BODY></HTML> Thu, 06 May 2010 13:18:34 GMT https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233523#M85060 2010-05-06T13:18:34Z lookup function not recognized https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233524#M85061 <HTML><HEAD></HEAD><BODY><P>Is that your expression or is that just from the help? In the Reference Manual, there are single quotes around each parameter. In your example, you don't have quotes around InvoicedProd. Also, you don't want quotes around the whole thing, but I'm guessing you just added those to separate the expression in your post?</P></BODY></HTML> Thu, 06 May 2010 14:53:41 GMT https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233524#M85061 2010-05-06T14:53:41Z lookup function not recognized https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233525#M85062 <HTML><HEAD></HEAD><BODY><P>Hi NMIller,<BR />its from the manuals, mine one is like this lookup('DocType',"InvoiceID", InvoiceID).</P><P>I left the second InvoiceID out of the qoutes coz i want to use the running InvoiceID, that's is invoice for that row.</P><P>Regards</P></BODY></HTML> Thu, 06 May 2010 15:04:28 GMT https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233525#M85062 2010-05-06T15:04:28Z lookup function not recognized https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233526#M85063 <HTML><HEAD></HEAD><BODY><P>Ok. I don't know if you can alternate quote types. I would stick with single quotes, since that is what the manual uses. You may still need to put quotes around the InvoiceId value. I would first verify that it works with a pre-defined value. Hardcode one of your InvoiceIDs in there with quotes around it and see if you still get the error. If so, something else is wrong, if not, then try:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">lookup('DocType',"InvoiceID", Chr(39) &amp; InvoiceID &amp; Chr(39))</PRE></BLOCKQUOTE><BR /><BR /> <P>That should give you the dynamic InvoiceID, but put quotes around it.</P></BODY></HTML> Thu, 06 May 2010 16:05:07 GMT https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233526#M85063 2010-05-06T16:05:07Z lookup function not recognized https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233527#M85064 <HTML><HEAD></HEAD><BODY><P>Are you using lookup() in script or a chart expression? Lookup() is a script only function.</P><P>-Rob</P></BODY></HTML> Thu, 06 May 2010 17:37:53 GMT https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233527#M85064 rwunderlich 2010-05-06T17:37:53Z lookup function not recognized https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233528#M85065 <HTML><HEAD></HEAD><BODY><P>my problem is i have a set or data like , how do i write an expression for</P><P>1. All IDs without ProfID,</P><P>2. All ProfIDs without InvID</P><P></P><TABLE><TBODY><TR><TD>ID</TD><TD>profID</TD><TD>InvID</TD><TD>DocType</TD></TR><TR><TD>1</TD><TD>null</TD><TD>null</TD><TD>enq</TD></TR><TR><TD>1</TD><TD>1</TD><TD>null</TD><TD>prof</TD></TR><TR><TD>1</TD><TD>2</TD><TD>null</TD><TD>prof</TD></TR><TR><TD>1</TD><TD>null</TD><TD>2</TD><TD>inv</TD></TR><TR><TD>3</TD><TD>null</TD><TD>null</TD><TD>enq</TD></TR><TR><TD>4</TD><TD>null</TD><TD>null</TD><TD>enq</TD></TR><TR><TD>4</TD><TD>3</TD><TD>null</TD><TD>prof</TD></TR></TBODY></TABLE><P></P><P></P><P>Regards,</P></BODY></HTML> Fri, 07 May 2010 10:06:40 GMT https://community.qlik.com/t5/QlikView/lookup-function-not-recognized/m-p/233528#M85065 2010-05-07T10:06:40Z