sql and table

[#1]

Hello,

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?

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

thanks in advance

[ramoncova06]

I would have to see the format of the fields in the file, but have you tried playing with file delimiter properties

something like

(txt, codepage is 1252, embedded labels, delimiter is ',')

WHERE City = 'Bangkok'; 

[maxgro]

try

where wildmatch(City, '*Bangkok*')

[MarcoWedel]

Hi,

maybe

WHERE City like '*Bangkok*';

could do if there are some other characters included in this field.

regards

Marco

[petter]

Try:

WHERE Trim(Upper(City)) = 'BANGKOK'

[anbu1984]

Don't create duplicate post

How do I make sql query in qlikview