Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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!!