topic Trouble with WHERE in script in QlikView

Trouble with WHERE in script

stark___ — Mon, 26 Nov 2012 11:29:36 GMT

Hello,

I have a trouble with function "Where" in script.

I have a script:

ODBC CONNECT TO [Database MS Access;DBQ=D:\QlikViewAdm\sales.mdb];

SQL SELECT 'Date',

`Distributor`,

`Salesman`,

`Client`,

`Region`,

`City`,

`Product`,

`quantity`,

`amount`

FROM `for pivot`;

and I want to download sales only one definite distributor. I try to use such expressions in the script:

WHERE Distributor='GLP JSC'

WHERE match(Distributor, 'GLP JSC')

but I always get error: "Syntax error (missing operator) in query expression"

Can you help me?

Best regards, Stark

Re: Trouble with WHERE in script

happydays1967 — Mon, 26 Nov 2012 11:33:25 GMT

In my experience, when you do a select on an ODBC source, the SQL dialect used is that of source engine. You might try to create a query in MS Access and then copy the SQL and paste it into your script....

Re: Trouble with WHERE in script

Mon, 26 Nov 2012 11:37:33 GMT

SQL SELECT 'Date',

`Distributor`,

`Salesman`,

`Client`,

`Region`,

`City`,

`Product`,

`quantity`,

`amount`

FROM `for pivot`;

and I want to download sales only one definite distributor. I try to use such expressions in the script:

WHERE Distributor='GLP JSC'

WHERE match(Distributor, 'GLP JSC');

try this script i think ; this was missed in u r script

Re: Trouble with WHERE in script

jagan — Mon, 26 Nov 2012 12:15:59 GMT

Hi,

Try this script

SQL SELECT 'Date',

`Distributor`,

`Salesman`,

`Client`,

`Region`,

`City`,

`Product`,

`quantity`,

`amount`

FROM `for pivot`

WHERE Distributor='GLP JSC';

This should work, if not can you attach full script.

Regards,

Jagan.

Re: Trouble with WHERE in script

stark___ — Fri, 30 Nov 2012 09:26:35 GMT

Hello,

I tried your advice, but, unfortunately, it doesn't work. I attached my script and database, can you test it?

Best regards, Stark

Re: Trouble with WHERE in script

Fri, 30 Nov 2012 10:07:33 GMT

Hi Stark,

PFA the qvw file.

Hope this helps.

Regards,

Neha Rangari

Re: Trouble with WHERE in script

stark___ — Fri, 30 Nov 2012 11:05:33 GMT

Thank you, it work perfect.

Regards, Stark

Re: Trouble with WHERE in script

stark___ — Fri, 30 Nov 2012 11:13:10 GMT

Thank you Jagan, you were right, and your advice is correct. I had to just replace " ; " from "FROM `for pivot`;" to "WHERE Distributor='GLP JSC';"

Regards, Stark