topic Re: Need Help in Columns creation in QlikView

Need Help in Columns creation

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 30 Aug 2018 09:11:10 GMT

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 — Thu, 30 Aug 2018 09:19:17 GMT

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 — Thu, 30 Aug 2018 09:25:12 GMT

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 — Thu, 30 Aug 2018 09:55:15 GMT

Okay thanks let me try.