topic Re: If Statement in QlikView

If Statement

Anonymous — Tue, 12 Jan 2016 10:09:12 GMT

Hi All

I am trying to create an IF Statement

if (StatusDesc = 'BI: BAU - PRIORITY',1),

if (StatusDesc = 'BI: DEV - PRIORITY',2),

if (StatusDesc = 'BI: SALES - PRIORITY',3),0 as PriorityStatus,

what am i doing wrong?

Thanks All

Adil

Anonymous — Tue, 12 Jan 2016 10:10:37 GMT

try this:

if (StatusDesc = 'BI: BAU - PRIORITY',1,

if (StatusDesc = 'BI: DEV - PRIORITY',2,

if (StatusDesc = 'BI: SALES - PRIORITY',3))) as PriorityStatus,

Anonymous — Tue, 12 Jan 2016 10:12:09 GMT

Thanks Balraj for quick and correct response!

tamilarasu — Tue, 12 Jan 2016 10:12:32 GMT

Try any one of this method,

Pick(Match(StatusDesc, 'BI: BAU - PRIORITY','BI: DEV - PRIORITY', 'BI: SALES - PRIORITY')+1,1,2,3,0) as PriorityStatus,

If (StatusDesc = 'BI: BAU - PRIORITY',1,

If (StatusDesc = 'BI: DEV - PRIORITY',2,

If (StatusDesc = 'BI: SALES - PRIORITY',3,0))) as PriorityStatus,

Tue, 12 Jan 2016 10:12:36 GMT

if (StatusDesc = 'BI: BAU - PRIORITY',1,

if (StatusDesc = 'BI: DEV - PRIORITY',2,

if (StatusDesc = 'BI: SALES - PRIORITY',3,0

)))as PriorityStatus,

Anonymous — Tue, 12 Jan 2016 10:12:57 GMT

Anonymous — Tue, 12 Jan 2016 10:27:43 GMT

Thanks for the help

Anonymous — Tue, 12 Jan 2016 10:27:58 GMT

Thanks for the help