topic Case Select in QlikView https://community.qlik.com/t5/QlikView/Case-Select/m-p/519341#M693335 <HTML><HEAD></HEAD><BODY><P>How would I accomplish the non-working pseudocode below in QV?</P><P></P><P>Load</P><P>&nbsp; URL,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; (Select Case URL</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case wildmatch(URL,'*abc*) : ABC</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case wildmatch(URL,'*def*') : DEF</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case wildmatch(URL,'*ghi*') : GHI</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Default: XYZ</P><P>&nbsp;&nbsp;&nbsp;&nbsp; End Select) as ProductCode</P><P>From AnyTable.qvd(qvd);</P></BODY></HTML> Thu, 22 Aug 2013 14:25:09 GMT Anonymous 2013-08-22T14:25:09Z Case Select https://community.qlik.com/t5/QlikView/Case-Select/m-p/519341#M693335 <HTML><HEAD></HEAD><BODY><P>How would I accomplish the non-working pseudocode below in QV?</P><P></P><P>Load</P><P>&nbsp; URL,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; (Select Case URL</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case wildmatch(URL,'*abc*) : ABC</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case wildmatch(URL,'*def*') : DEF</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case wildmatch(URL,'*ghi*') : GHI</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Default: XYZ</P><P>&nbsp;&nbsp;&nbsp;&nbsp; End Select) as ProductCode</P><P>From AnyTable.qvd(qvd);</P></BODY></HTML> Thu, 22 Aug 2013 14:25:09 GMT https://community.qlik.com/t5/QlikView/Case-Select/m-p/519341#M693335 Anonymous 2013-08-22T14:25:09Z Re: Case Select https://community.qlik.com/t5/QlikView/Case-Select/m-p/519342#M693336 <HTML><HEAD></HEAD><BODY><P>pick(wildmatch(URL, '*abc*','*def*','*ghi*')+1,'XYZ','ABC','DEF','GHI') as ProductCode</P></BODY></HTML> Thu, 22 Aug 2013 14:31:27 GMT https://community.qlik.com/t5/QlikView/Case-Select/m-p/519342#M693336 Gysbert_Wassenaar 2013-08-22T14:31:27Z