Edit Script Selections

[mohiahmed]

Hello

I was wondering if anyone ca help please.

In the Edit script, I am trying to being in certain selection however I can't get it to work.

Please see below my load script

Directory;

LOAD ID as [CH_ID],

     //SOURCESYSTEMID,

     //TYPECODE,

     //STATUSCODE,

     TYPENAME,

     STATUSNAME,

     AREA,

     //DEFAULTQUEUECODE,

     DEFAULTQUEUENAME,

  ALFAETLLOGID,

     EFF_STA_DTE,

     EFF_END_DTE

     //DW_UPD_LOD_TMP,

     //DW_LOD_TMP

FROM

CASESTATUS_TBL.QVD

(qvd)

WHERE (((DEFAULTQUEUENAME) In ('Service Quality','Servicing','Terminations','Reports','Onshore Operations','Offshore Case Manager','End of Lease')));

[tresesco]

Try replacing IN with Match(), like:

...WHERE Match( DEFAULTQUEUENAME ,'Service Quality','Servicing','Terminations','Reports','Onshore Operations','Offshore Case Manager','End of Lease' );

[prma7799]

instead of IN use wildmatch

LOAD ID as [CH_ID],

     //SOURCESYSTEMID,

     //TYPECODE,

     //STATUSCODE,

     TYPENAME,

     STATUSNAME,

     AREA,

     //DEFAULTQUEUECODE,

     DEFAULTQUEUENAME,

  ALFAETLLOGID,

     EFF_STA_DTE,

     EFF_END_DTE

     //DW_UPD_LOD_TMP,

     //DW_LOD_TMP

FROM

CASESTATUS_TBL.QVD

(qvd)

WHERE WildMatch(DEFAULTQUEUENAME ,'Service Quality','Servicing','Terminations','Reports','Onshore Operations','Offshore Case Manager','End of Lease');

[Or]

There's no "IN" in QlikView syntax. Try using Match().

[mohiahmed]

Thank you all for you help