topic Re: Need logic during load statement in QlikView

Need logic during load statement

Mon, 22 Sep 2014 09:13:51 GMT

Hi All,

Need logic during load statement as below.

Load Date,

Status,

If (status = ‘completed’ keep same.

If status = ‘low’ and date is not null ‘Completed’ else ‘low’

If status = ‘High and date is not null ‘Completed’ else ‘High

If status = ‘Medium and date is not null ‘Completed’ else ‘Medium’) as NEW STATUS,

MK_QSL — Mon, 22 Sep 2014 09:18:13 GMT

IF(status = 'completed',status,

IF(status = 'low' and not IsNull(date),'completed',

IF(status = 'low' and IsNull(date),'low',

IF(status = 'High' and not IsNull(date),'completed',

IF(status = 'High' and IsNull(date),'High',

IF(status = 'Medium' and not IsNull(date),'completed',

IF(status = 'Medium' and IsNull(date),'Medium'))))))) as NEW STATUS

crusader_ — Mon, 22 Sep 2014 09:21:18 GMT

Hi,

Load

Date,

Status,

if(match(status,'completed'), status,

if( match(status,'low') and not isnull(Date), 'low',

if( match(status,'High ') and not isnull(Date), 'High',

if( match(status,'Medium ') and not isnull(Date), 'Medium'

)

) as NEW_STATUS

You definetely should have some TaskId, pls share your data sample.

HTH

Andrei

perumal_41 — Mon, 22 Sep 2014 09:26:07 GMT

Try below expression

IF(status = 'completed' or (match(status, 'low','High','Medium')>0 and not IsNull(date)),'completed',status)

Mon, 22 Sep 2014 10:08:15 GMT

Thanks to all.