topic Re: if and not like.. in QlikView

if and not like..

Tue, 10 Mar 2015 09:37:19 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 !

Re: if and not like..

datanibbler — Tue, 10 Mar 2015 09:39:58 GMT

Hi sap,

just try WILDMATCH() - combined with NOT, so it would be NOT(WILDMATCH()) - in that, you can use the *

- alternatively, you could use LEFT(Catalogue_marque, 3) to split out those letters which should be > API < ...

HTH

Best regards,

DataNibbler

Re: if and not like..

simenkg — Tue, 10 Mar 2015 09:42:47 GMT

and (not Wildmatch(Catalogue_marque ,'API*'))

Re: if and not like..

puttemans — Tue, 10 Mar 2015 09:44:44 GMT

Try the following :

if (catalogue_famille='LEGUMES 4G',

IF(FACTURE_INC.GPE_CLIENT='RESTALLIANCE',

IF(not Wildmatch(Catalogue_marque ,'API*')),

'OK','Interdit'))) as Test

Re: if and not like..

PrashantSangle — Tue, 10 Mar 2015 09:45:08 GMT

Hi,

Try with wildmatch() or match()

Try like

if (wildmatch(catalogue_famille,'LEGUMES 4G') and wildmatch(FACTURE_INC.GPE_CLIENT,'RESTALLIANCE')

and not wildmatch(Catalogue_marque,'API*'),'OK','Interdit') as Test

Regards

Re: if and not like..

Anonymous — Tue, 10 Mar 2015 09:45:57 GMT

Try below code :

FACTURE_INDICATEUR3:

LOAD

FACTURE_INC.GPE_CLIENT,

FACTURE_INC.CodifCreno,

Catalogue_marque,

left(Catalogue_marque,3) as Catalogue_marque1

catalogue_famille,

if ((catalogue_famille='LEGUMES 4G') and (FACTURE_INC.GPE_CLIENT='RESTALLIANCE')

and (Catalogue_marque1<>'API' ),'OK','Interdit') as Test

FROM

FACTURE_INDICATEUR.QVD

(qvd);

Re: if and not like..

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

Hi,

Try like this

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 (not Catalogue_marque like 'API*' ),'OK','Interdit') as Test

FROM

FACTURE_INDICATEUR.QVDu

(qvd);

Hope this helps you.

Regards,

Jagan.

Re: if and not like..

Tue, 10 Mar 2015 10:02:36 GMT

Thanks a lot everybody !!!