topic Re: Restricting data from a web file in QlikView

Restricting data from a web file

Qlik_Enthu — Fri, 07 Jul 2017 09:42:31 GMT

Dear All,

I am loading a map data (csv) from here: https://developers.google.com/public-data/docs/canonical/countries_csv] . Is it possible to restrict the data in other words, is it possible to add a where condition in the data load script?

ahaahaaha — Fri, 07 Jul 2017 09:55:40 GMT

Hi,

Example

LOAD country,

latitude,

longitude,

name

FROM

(html, codepage is 1251, embedded labels, table is @1)

Where name= 'Andorra' Or name='Armenia';

Qlik_Enthu — Fri, 07 Jul 2017 10:04:36 GMT

I wanted to select Where Country_Code using the IN clause. but when I add where condition the query wouldn'`t work

tresB — Fri, 07 Jul 2017 10:09:25 GMT

Qlikview's replacement for IN could be Match(). Try like:

...Where Match(Country_Code, 'Code1', ....)

Kushal_Chawda — Fri, 07 Jul 2017 10:20:34 GMT

or go on to this link and export the file into CSV and load it in QlikView

Qlik_Enthu — Fri, 07 Jul 2017 11:53:37 GMT

Thank you so much..it worked