topic Re: sql and table in QlikView

sql and table

Tue, 28 Apr 2015 17:46:23 GMT

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 — Tue, 28 Apr 2015 18:20:16 GMT

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 — Tue, 28 Apr 2015 20:41:17 GMT

try

where wildmatch(City, '*Bangkok*')

MarcoWedel — Tue, 28 Apr 2015 22:10:51 GMT

Hi,

maybe

WHERE City like '*Bangkok*';

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

regards

Marco

petter — Wed, 29 Apr 2015 01:24:36 GMT

Try:

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

anbu1984 — Wed, 29 Apr 2015 05:35:38 GMT

Don't create duplicate post