topic Re: Help with IF statement in QlikView

Help with IF statement

Wed, 05 Jun 2013 15:14:40 GMT

Please can you help me, this is the code I have used and it doesn't pull anything through:

I'm new to qlikview and not sure how IF statements work, I want it to say, if (start difference) is>=-10 and <=10 then 'On time'

else if (start diff) <=-10 then 'Early Start' else if (start difference) >10 'Late Start'

In Qlikview:

=(if (session_start_difference >= -10 and session_start_difference <=10, 'On Time')

or if ( session_start_difference <= -10, 'Early Start'

or if( session_start_difference >10, 'Late Start')))

Re: Help with IF statement

ariel_klien — Wed, 05 Jun 2013 15:21:11 GMT

HI,

try to do this:

=(if (session_start_difference >= -10 and session_start_difference <=10, 'On Time',

if ( session_start_difference <= -10, 'Early Start', if( session_start_difference >10, 'Late Start'))))

Ariel

Re: Help with IF statement

sushil353 — Wed, 05 Jun 2013 15:22:55 GMT

Hi Try this:

=if (session_start_difference >= -10 and session_start_difference <=10, 'On Time',if ( session_start_difference <= -10, 'Early Start',session_start_difference >10, 'Late Start'))

HTH

Sushil

Re: Help with IF statement

Wed, 05 Jun 2013 15:23:50 GMT

Thank you!!