topic Re: Edit Script Selections in QlikView

Edit Script Selections

mohiahmed — Wed, 25 Nov 2020 16:16:04 GMT

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')));

Re: Edit Script Selections

tresB — Wed, 01 Nov 2017 10:25:30 GMT

Try replacing IN with Match(), like:

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

Re: Edit Script Selections

prma7799 — Wed, 01 Nov 2017 10:28:10 GMT

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');

Re: Edit Script Selections

Or — Wed, 01 Nov 2017 10:30:51 GMT

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

Re: Edit Script Selections

mohiahmed — Wed, 01 Nov 2017 11:18:30 GMT

Thank you all for you help