topic Nested IF or use variable? in QlikView

Nested IF or use variable?

Sat, 17 Oct 2009 04:00:11 GMT

I'm a newbie. Currently I am using nested IFs in a LOAD statement. Something like this:

LOAD Region,

IF (Region='UK','Europe',

IF (Region='Germany','Europe',

IF (Region='France','Europe, Region) AS WWRegion,

This works fine but I am loading several tables from several data sources and have to use this same structure and values in several LOAD statements. If I add another country to Europe, I need to go modify the script in several places. I am wanting to setup some sort of variable that is a table or set of values. Something like this:

SET EUCountries = {'UK','Germany','France'};

LOAD Region

IF (Region=EUCountries,'Europe',Region) AS WWRegion,

Is this something that can be done in a QlikView script? If so, what is the specific syntax?

Any help is appreciated. Thanks!

Nested IF or use variable?

Sat, 17 Oct 2009 14:37:16 GMT

Use of mapping tables will be an easier and generalized approach.

1. Creata a mapping table with country as key and region as the mapped field

2. 'applymap' the region against the country whenever you load data from the respective QVD.

Initial SQL load need to require any conditional if in this case.

--Arun

Nested IF or use variable?

Mon, 19 Oct 2009 22:34:25 GMT

Thanks Arun. I'll give this a try.

Regards.