topic match function in expression with variable list in QlikView https://community.qlik.com/t5/QlikView/match-function-in-expression-with-variable-list/m-p/368146#M136901 <HTML><HEAD></HEAD><BODY><P>I'm confused.&nbsp; I have a variable called:</P><P></P><P>vDealerList with a definition of 333,334,335</P><P></P><P>IN an expressions, if [dealernumber] is equal to 333, this works, match([dealernumber],333,334,335) returning 1.</P><P></P><P>However, this will not, match([dealernumber],vDealerList), this returns 0</P><P></P><P>Am I missing somethign?</P></BODY></HTML> Thu, 24 May 2012 15:31:33 GMT 2012-05-24T15:31:33Z match function in expression with variable list https://community.qlik.com/t5/QlikView/match-function-in-expression-with-variable-list/m-p/368146#M136901 <HTML><HEAD></HEAD><BODY><P>I'm confused.&nbsp; I have a variable called:</P><P></P><P>vDealerList with a definition of 333,334,335</P><P></P><P>IN an expressions, if [dealernumber] is equal to 333, this works, match([dealernumber],333,334,335) returning 1.</P><P></P><P>However, this will not, match([dealernumber],vDealerList), this returns 0</P><P></P><P>Am I missing somethign?</P></BODY></HTML> Thu, 24 May 2012 15:31:33 GMT https://community.qlik.com/t5/QlikView/match-function-in-expression-with-variable-list/m-p/368146#M136901 2012-05-24T15:31:33Z match function in expression with variable list https://community.qlik.com/t5/QlikView/match-function-in-expression-with-variable-list/m-p/368147#M136902 <HTML><HEAD></HEAD><BODY><P>Try a dollar sign expansion:</P><P></P><P>match([dealernumber],$(vDealerList) )</P></BODY></HTML> Thu, 24 May 2012 15:41:44 GMT https://community.qlik.com/t5/QlikView/match-function-in-expression-with-variable-list/m-p/368147#M136902 swuehl 2012-05-24T15:41:44Z