topic Re: How do I make sql query in qlikview in QlikView

How do I make sql query in qlikview

Tue, 28 Apr 2015 12:35:37 GMT

Hello,

I have made a where sql query in qlikview, but it does not work. I want only see the city bangkok.

Can someone help me?

The code is:

Land1:

LOAD Land,

City,

FROM

Gegevensbronnen\Land1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof)

WHERE City = ("Bangkok");

Re: How do I make sql query in qlikview

Anonymous — Tue, 28 Apr 2015 12:40:56 GMT

This:

...

WHERE City = 'Bangkok';

Re: How do I make sql query in qlikview

anbu1984 — Tue, 28 Apr 2015 12:43:30 GMT

WHERE WildMatch(City,"Bangkok");

Re: How do I make sql query in qlikview

Anonymous — Tue, 28 Apr 2015 12:44:27 GMT

load city

from

yourfile

where city ='bangkok'

Re: How do I make sql query in qlikview

Tue, 28 Apr 2015 12:44:37 GMT

Use:

Land1:

LOAD Land,

City

FROM

Gegevensbronnen\Land1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof)

WHERE City = 'Bangkok';

Re: How do I make sql query in qlikview

Tue, 28 Apr 2015 13:00:07 GMT

And you need a log in Sub or somthing else:

sub connectToDB

if (vERP = 'cee') then
   if (vDBType = 'mssql2005') then
   ODBC CONNECT32 TO [STS_SC] (XUserId is Matthias, XPassword is abcd);
else
   ODBC CONNECT TO CEE_5_BDV (XUserId is Matthias, XPassword is abcd);
end if
elseif (vERP = 'css') then
   ODBC CONNECT TO CSS_export (XUserId is Matthias, XPassword is abcd);

else
   // f. Postgres or SQL Server)
if (vDBType = 'mssql2005') then
   ODBC CONNECT32 TO $(vODBC_DSN);
else
   ODBC CONNECT64 TO $(vODBC_DSN);
end if
end if
end Sub

Re: How do I make sql query in qlikview

Tue, 28 Apr 2015 13:13:09 GMT

After Then:

$(Include=$..\..\connect.qvs);

call connectToDB;

LOAD field_a AS account, field_b AS sales,
...;
SQL SELECT * FROM account;

Re: How do I make sql query in qlikview

Tue, 28 Apr 2015 13:15:21 GMT

the qvs is a C# script and the other "Include...LOAD... SQL; is in the Script of the Generator. I hope it help you!

Re: How do I make sql query in qlikview

awhitfield — Tue, 28 Apr 2015 13:20:21 GMT

HI Maichel

Single quotes around Bankok, and it's case sensitive too!

Land1:

LOAD Land,

City,

FROM

Gegevensbronnen\Land1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof)

WHERE City = 'Bangkok';

Re: How do I make sql query in qlikview

Tue, 28 Apr 2015 17:02:42 GMT

thanks for info,

But I have the cities in a table, when I use the where City = 'Bangkok' then qlikview shows all cities.

Do you know what I can do that I only get bangkok and not all cities?

thanks in advance.

Re: How do I make sql query in qlikview

anbu1984 — Wed, 29 Apr 2015 04:59:40 GMT

Can you post sample input file

Re: How do I make sql query in qlikview

Wed, 29 Apr 2015 05:38:05 GMT

Then you have a other data format.But I havent worked with a csv. Only with Postgres, SQL or Excel.

LOAD text(code) as c_code,

customer as greatCustomer

FROM

[$(activ_drive)\customer2.xlsx]

(ooxml, embedded labels, table is cust) where code<>0;

Re: How do I make sql query in qlikview

awhitfield — Wed, 29 Apr 2015 08:37:42 GMT

Can you post the qvw and your source data file?

Andy