Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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')))
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'))))
BR
Ariel
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'))))
BR
Ariel
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
Thank you!!