topic Re: If and not like... in QlikView

If and not like...

Tue, 10 Mar 2015 09:36:45 GMT

Hi everybody,

i gat an issue i have a table, and i want to add a field but i don't manage with the conditionnal logics.

FACTURE_INDICATEUR3:

LOAD

FACTURE_INC.GPE_CLIENT,

FACTURE_INC.CodifCreno,

Catalogue_marque,

catalogue_famille,

if ((catalogue_famille='LEGUMES 4G') and (FACTURE_INC.GPE_CLIENT='RESTALLIANCE') and (Catalogue_marque not like API* ),'OK','Interdit') as Test

FROM

FACTURE_INDICATEUR.QVD

(qvd);

But there is a problem with the not like.. any one can help me?

Thanks you so much ! And sorry for my bad english !

Gysbert_Wassenaar — Tue, 10 Mar 2015 09:49:34 GMT

Try and not wildmatch(Catalogue_marque, 'API*')

jagan — Tue, 10 Mar 2015 09:55:57 GMT

Hi,

Try like this