topic Re: Help using WHERE in QlikView

Help using WHERE

bazzaonline — Fri, 16 Jan 2015 10:06:53 GMT

Hello, I have the below script and I want to add a WHERE in the script so it only pulls back data where the "D_Claim_Entered" is newer than 30/06/2014. I can't get it to work. The date is in the format 01/0/2015 00:00:00.

OLEDB CONNECT TO ...............................................xxx

LOAD "N_CLAIM_NUMBER" AS "Claim Number",,

"D_CLAIM_ENTERED",

"T_SHRT_TXT";

SQL SELECT TOP 1000 "N_CLAIM_NUMBER",

"D_CLAIM_ENTERED",

"T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All";

STORE Notes Into Notes.qvd

Re: Help using WHERE

alexandros17 — Fri, 16 Jan 2015 10:11:19 GMT

Try with

.....

SELECT "N_CLAIM_NUMBER",

"D_CLAIM_ENTERED",

"T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All"

Where N_CLAIM_NUMBER >= '20150101'

.....

let me know

Re: Help using WHERE

Gysbert_Wassenaar — Fri, 16 Jan 2015 10:11:38 GMT

Try

SQL SELECT TOP 1000 "N_CLAIM_NUMBER",

"D_CLAIM_ENTERED",

"T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All"

WHERE "D_CLAIM_ENTERED" > '30/06/2014' ;

Re: Help using WHERE

Fri, 16 Jan 2015 10:14:30 GMT

Try something like this:

OLEDB CONNECT TO ...............................................xxx

LOAD "N_CLAIM_NUMBER" AS "Claim Number",,

"D_CLAIM_ENTERED",

"T_SHRT_TXT"

Where "D_CLAIM_ENTERED" > Date('30/06/2014', 'DD/MM/YYYY') ;

SQL SELECT TOP 1000 "N_CLAIM_NUMBER",

"D_CLAIM_ENTERED",

"T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All";

STORE Notes Into Notes.qvd

Re: Help using WHERE

PrashantSangle — Fri, 16 Jan 2015 10:20:14 GMT

Hi,

Use solution given above if not worked then try same logic with

to_Char() or to_Date() while comparing.

Regards