Need Help in Columns creation

[soniasweety]

Hi All,

i need to build below code in qlikview  how can i  create this in Qlikview

1.  Left(Property,2)       

2. if(type in('Cll / Ul','Nes','Ul'),'New','Existing')

3.if(RR in('01','02','03','04','05') then 'open','Closed')

[Anonymous]

1.  Left(Property,2)       

2. if(match(type,'Cll / Ul','Nes','Ul'),'New','Existing')

3.if(match(RR,'01','02','03','04','05'),'open','Closed')

[soniasweety]

thanks

but here

im creating   left(Property,2)  as RR

the above RR  i need to use in 3rd expression

3.if(match(RR,'01','02','03','04','05'),'open','Closed')

my question is derived column will work in this expression?

[Anonymous · Accepted solution]

you may use the Expression left(property,2) in following expressions like

if (match(left(Property,2),'01','02','03','04','05'),'open','Closed')

Where do you want to use left(Property,2) as RR?

in a script load you may use a preload like

TEST:

load *,

if(match(RR,'01','02','03','04','05'),'open','Closed');

load

  left(Property,2) as RR

...

...

from

[soniasweety]

Okay thanks let me try.