topic Re: Using Where in Scripts in QlikView

Using Where in Scripts

Anonymous — Tue, 23 May 2017 18:36:42 GMT

I am trying to add a 2nd where clause in my load scripts to bring back claims that are only Open and Closed and I keep getting a load error, below is how I have it now...

SQL SELECT *
FROM "ACT_DBASES_PROD".dbo."WC_CLAIM_ADJUSTERS"
Where ([SNAPSHOT_CCYYMM] >='201701') AND
Where Match ([CLAIM_STATE]='Open','Closed')

Re: Using Where in Scripts

sunny_talwar — Tue, 23 May 2017 18:38:49 GMT

May be try this

SQL SELECT *
FROM "ACT_DBASES_PROD".dbo."WC_CLAIM_ADJUSTERS"
Where ([SNAPSHOT_CCYYMM] >='201701') AND [CLAIM_STATE] IN ('Open','Closed');

Re: Using Where in Scripts

Anonymous — Tue, 23 May 2017 18:44:15 GMT

Thank You Sunny that worked!!!!

Re: Using Where in Scripts

sunny_talwar — Tue, 23 May 2017 18:45:54 GMT

Awesome

Re: Using Where in Scripts

vishsaggi — Tue, 23 May 2017 18:51:41 GMT

Hello Tom,

Can you close the thread by marking Correct answer you got.