Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for
Did you mean:
Not applicable

## Help with IF statement

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')))

1 Solution

Accepted Solutions
Specialist

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

3 Replies
Specialist

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

Master II

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

Not applicable
Author

Thank you!!

Community Browser