Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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')))

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Help with IF statement

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
Highlighted
Specialist
Specialist

Re: Help with IF statement

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

Highlighted
Master II
Master II

Re: Help with IF statement

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

Highlighted
Not applicable

Re: Help with IF statement

Thank you!!