Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jerryhnc
New Contributor III

Case Select

How would I accomplish the non-working pseudocode below in QV?

Load

  URL,

     (Select Case URL

          Case wildmatch(URL,'*abc*) : ABC

          Case wildmatch(URL,'*def*') : DEF

          Case wildmatch(URL,'*ghi*') : GHI

          Default: XYZ

     End Select) as ProductCode

From AnyTable.qvd(qvd);

1 Reply

Re: Case Select

pick(wildmatch(URL, '*abc*','*def*','*ghi*')+1,'XYZ','ABC','DEF','GHI') as ProductCode


talk is cheap, supply exceeds demand
Community Browser