Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

adoteykwame
Contributor

IF with Mixmatch and And ......

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;

2 Replies

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

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.


talk is cheap, supply exceeds demand
MVP
MVP

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

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.

Community Browser