topic Re: Script prob in QlikView

Script prob

nikhilgarg — Wed, 29 Jul 2015 06:22:04 GMT

Hey,

My script is:

Load CityId,

Cityname

CountryCode

from abc.qvd ;

i want to apply condn where Country Code = US and CA

I applied like:

Load CityId,

Cityname

CountryCode

from abc.qvd where CountryCode = {'US' , 'CA'} ; but giving error.

Re: Script prob

tresB — Wed, 29 Jul 2015 06:25:45 GMT

Try like:

Load CityId,

Cityname,

CountryCode

from abc.qvd where Match(CountryCode, 'US' , 'CA') ;

Edit: Corrected a comma.

Re: Script prob

sushil353 — Wed, 29 Jul 2015 06:27:02 GMT

Hi,

Try this:

Load CityId,

Cityname

CountryCode

from abc.qvd where Match(CountryCode ,'US' , 'CA') ;

Re: Script prob

sunilkumarqv — Wed, 29 Jul 2015 06:31:15 GMT

try this

Load CityId,

Cityname,

CountryCode

from abc.qvd where CountryCode='US' and CountryCode='CA';

Load CityId,

Cityname,

CountryCode

from abc.qvd where Match(CountryCode,'US' ,'CA');

Re: Script prob

ashwanin — Wed, 29 Jul 2015 06:45:28 GMT

Use Where Match (CountryCode,'US','CA') ;

Re: Script prob

qlikviewwizard — Wed, 29 Jul 2015 06:52:25 GMT

Use like this:

LOAD CITYID,

CITYNAME,

COUNTRYCODE

FROM ABC.QVD WHERE MATCH(COUNTRYCODE,'US' ,'CA');

Re: Script prob

nikhilgarg — Wed, 29 Jul 2015 07:18:29 GMT

Hey,

I have used like:

Table1:

Load CityId,

Cityname,

CountryCode

from abc.qvd ;

Table2:

Load * resident Table1 where CountryCode = Match(CountryCode, 'US', 'CA') ;

Is this also ryt ?

Re: Script prob

nikhilgarg — Wed, 29 Jul 2015 07:18:42 GMT

Hey,

I have used like:

Table1:

Load CityId,

Cityname,

CountryCode

from abc.qvd ;

Table2:

Load * resident Table1 where CountryCode = Match(CountryCode, 'US', 'CA') ;

Is this also ryt ?

Re: Script prob

nikhilgarg — Wed, 29 Jul 2015 07:18:51 GMT

Hey,

I have used like:

Table1:

Load CityId,

Cityname,

CountryCode

from abc.qvd ;

Table2:

Load * resident Table1 where CountryCode = Match(CountryCode, 'US', 'CA') ;

Is this also ryt ?

Re: Script prob

qlikviewwizard — Wed, 29 Jul 2015 07:25:42 GMT

Hi,

Can you upload your file?

Thank you.

Re: Script prob

tresB — Wed, 29 Jul 2015 07:27:56 GMT

No. 'CountryCode = Match(CountryCode, 'US', 'CA') ; Try exactly how I showed above. For clearing doubt, read help for Match()