Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Need Help in Columns creation

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')





1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

4 Replies
Anonymous
Not applicable

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
Master
Master
Author

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
Not applicable

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
Master
Master
Author

Okay thanks let me try.