Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead 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
ariel_klien
Specialist
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

View solution in original post

3 Replies
ariel_klien
Specialist
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

sushil353
Master II
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!!