topic Re: IF with Mixmatch and And ...... in QlikView

IF with Mixmatch and And ......

Anonymous — Fri, 26 Apr 2013 13:04:11 GMT

Hi!

I dont seem to have the desired result...Help! This is what i want to do IF location is 'AC' AND 'CA' and source is 'S' then CODE

IF(TRIM(MIXMATCH(location,'AS','CA')) AND TRIM(Source) = 'S','S') AS CODE;

Re: IF with Mixmatch and And ......

Gysbert_Wassenaar — Fri, 26 Apr 2013 13:25:02 GMT

I don't think location can't have two values in the same record. So 'AC' AND 'CA' is not possible. If you want 'AC' or 'CA' then MIXMATCH(location,'AS','CA') won't work as AS is not AC. Try MIXMATCH(location,'AC','CA') instead. And possibly you want MIXMATCH(TRIM(location),'AC','CA') instead of putting the trim on the outside.

Re: IF with Mixmatch and And ......

jagan — Fri, 26 Apr 2013 14:02:40 GMT

Hi,

Try this

If(MixMatch(Trim(location),'AS','CA') AND Trim(Source) = 'S', CODE) AS CODE

Hope this helps you.

Regards,

Jagan.