topic Re: IF with No Match in QlikView

IF with No Match

Aldemarprins4 — Fri, 28 Jan 2022 17:26:41 GMT

Hello guys, I have the following problem, I have two countries that I want to exclude with an IF NO MATCH THEN, is it possible to do it?

Thank

AshutoshBhumkar — Fri, 28 Jan 2022 17:49:56 GMT

Hello,

If you want to exclude data in backend, you can use not match or not wildmatch.

e.g

Load

Country, CITY, Sales

From[................] where not match(Country,'A','B')

If from frontend then use '-='

E.g Sum({<Country - = {'A','B'}>}Sales)

Hope this helps.

Thanks,
Ashutosh

Aldemarprins4 — Fri, 28 Jan 2022 18:19:03 GMT

Thank but

I can do the following statement:

If(Not match ('Vcountry)'='Colombia',CostaRica'))

MarcoWedel — Fri, 28 Jan 2022 21:26:49 GMT

If(not Match(Vcountry,'Colombia','CostaRica'), then this, else that)

Aldemarprins4 — Fri, 28 Jan 2022 21:43:35 GMT

Thanks a lot