Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

tsoley341854
New Contributor II

Using Where in Scripts

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Using Where in Scripts

May be try this

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

4 Replies
MVP
MVP

Re: Using Where in Scripts

May be try this

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

tsoley341854
New Contributor II

Re: Using Where in Scripts

Thank You Sunny that worked!!!!

MVP
MVP

Re: Using Where in Scripts

Awesome

vishsaggi
Esteemed Contributor III

Re: Using Where in Scripts

Hello Tom,

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