topic Re: STRING (WHERE) in QlikView

STRING (WHERE)

adiarnon — Thu, 23 Oct 2014 04:52:50 GMT

HI,

I WANT ALL THE PCA WHERE THEIR PROJECT NOT STARTING WITH "DID"

IS THIS THE RIGHT WAY?

LOAD COMPANY&'-'&LOGISTIC_COMP&'-'&PROJECT&'-'&PCA AS T_Pca,
     COMPANY,
     LOGISTIC_COMP,
     PROJECT,
     PCA,
     PCA&' - '&PCA_NAME AS PcaNoName
FROM [..\..\DB\QVD\QV_DIM_PCA.qvd] (qvd)
Where PROJECT<>'DID%';

ADI

Re: STRING (WHERE)

tresB — Thu, 23 Oct 2014 05:07:09 GMT

Where not Wildmatch(PROJECT ,'DID*' );

Re: STRING (WHERE)

anbu1984 — Thu, 23 Oct 2014 05:07:42 GMT

Where Not PROJECT like 'DID*';

Where Not(Left(PROJECT,3) = 'DID' );

Re: STRING (WHERE)

its_anandrjs — Thu, 23 Oct 2014 07:08:28 GMT

Write like if the text start with word DID then try like

Regards,

Anand

Re: STRING (WHERE)

Anonymous — Thu, 23 Oct 2014 07:36:14 GMT

Where Left( PROJECT,3 ) <>'DID';

Re: STRING (WHERE)

jagan — Thu, 23 Oct 2014 07:39:58 GMT

Hi,

Try LIKE with wild card characters

Left(PROJECT, 3) <> 'DID';

Hope this helps you.

Regards,

jagan.

Re: STRING (WHERE)

its_anandrjs — Thu, 23 Oct 2014 07:42:27 GMT

Hi Adi,

There is lot of write answer suggested if got correct answer then mark Correct or Helpful for references and please close the thread.

Regards

Anand

Re: Re: STRING (WHERE)

tresB — Thu, 23 Oct 2014 08:01:23 GMT

If 'LIKE' is to be used, 'Not' should come immediate after WHERE, like:

Where PROJECT NOT LIKE 'DID*';

Where NOT PROJECT LIKE 'DID*';

This is because LIKE is an operator rather than a function.