Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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
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')
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?
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
Okay thanks let me try.