topic if clause in QlikView

if clause

Anonymous — Tue, 13 Oct 2015 15:25:16 GMT

I want to add severity=4 and 40 hours for that

if(Severity=1,3,if(Severity=2,5,if(Severity=3,24,'No_SLA'))) as KPI_TIME,

sunny_talwar — Tue, 13 Oct 2015 15:29:37 GMT

May be this:

If(Severity=1, 3,

If(Severity=2, 5,

If(Severity=3, 24,

If(Severity=4, YourNumber, 'No_SLA')))) as KPI_TIME,

nagaiank — Tue, 13 Oct 2015 15:29:45 GMT

Did you try

if(Severity=1,3

,if(Severity=2,5

,if(Severity=3,24

,If(Severity=4,40,'No_SLA')))) as KPI_TIME

maxgro — Tue, 13 Oct 2015 17:56:44 GMT

a different one

pick(wildmatch(Severity,1,2,3,4, '*'), 3, 5, 24, 40, 'No_SLA') as KPI_TIME