topic Re: If Condition Help in QlikView

If Condition Help

abhaysingh — Wed, 22 Apr 2015 08:11:10 GMT

i have zone like this East, North1, North2, North3, South1, South2, West1, West2

i want to it should come in single field Called Region with North, East West South...

if(Region = 'East','East' or

if(Region = 'North1','North2','North3' , 'North' or

if( Region = 'South1','South2' , 'South' or

if(Region = 'West1', 'West2', 'West')))) as Zone

will it work?

please Suggest

Re: If Condition Help

Anonymous — Wed, 22 Apr 2015 08:15:54 GMT

if(Region = 'East','East',

if(left(Region,5) = 'North',

if( left(Region,5) = 'South',

if(left(Regionm,4) = 'West')))) as Zone

should work!

This should be done ideally in the script (but can be done too in a calculated dimension)

Re: If Condition Help

abhaysingh — Wed, 22 Apr 2015 08:19:25 GMT

i want north1 , north2 , north 3 should combine into one

Re: If Condition Help

Anonymous — Wed, 22 Apr 2015 08:23:25 GMT

if(Region = 'East','East',

if(left(Region,5) = 'North', 'North'

if( left(Region,5) = 'South', 'South',

if(left(Regionm,4) = 'West','West')))) as Zone

sorry for mistake, it should be like 'East'

Re: If Condition Help

Anonymous — Wed, 22 Apr 2015 08:35:59 GMT

HI,

You should create a new table in your script like:

REGIONS:

LOAD * INLINE [

Region, Region2

East,East

North1,North

North2,North

North3,North

South1,South

South2 ,South

West1,West

West2,West ];

Then in your graphs you can use the dimension Region2

Re: If Condition Help

awhitfield — Wed, 22 Apr 2015 08:39:58 GMT

Hi Abhay,

see the attached simple example which illustrates Rudolph's suggestion.

Regards

Andy

Re: If Condition Help

anbu1984 — Wed, 22 Apr 2015 08:46:55 GMT

Pick(Wildmatch(Region,'East','*North*','*South*','*West*'),'East','North','South','West') As Zone