How do I make sql query in qlikview

[#1]

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");

[anbu1984]

Can you post sample input file

[#3]

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;

[awhitfield]

Can you post the qvw and your source data file?

Andy