Date Time Diff / If statement

Thu, 13 Jun 2013 12:49:08 GMT

Hi Please can you help:

I am trying to create a formula that will calculate the date/ time diiference between two times and depending on this number in minutes, I want it to display whether it is a late start by how many minutes, early start by how many minutes or started on time.

= (if (interval( session_actual_start - scheduled_start, 'mm') >-10, 'Started ' & interval (session_actual_start-scheduled_start, 'mm') & ' mins early',

if(session_start_difference >=-10 and session_start_difference <=10, 'Started On Time',

if (interval(session_actual_start - scheduled_start, 'mm') >10, 'Started ' & interval (session_actual_start-scheduled_finish, 'mm') & ' mins late'))))

This is the formula, which is working for Early starts but not picking up late starts, it still showing early start even though it is late.

Also, when it shows an early start it says: Started -50 mins early, how do I get rid of the - infont of the number?

Hope this makes sense and someone can help!

Thanks,

Re: Date Time Diff / If statement

Gysbert_Wassenaar — Thu, 13 Jun 2013 12:58:00 GMT

You can use the fabs() function so that negative numbers are made positive:

if (interval( session_actual_start - scheduled_start, 'mm') <-10, 'Started ' & interval (fabs(session_actual_start-scheduled_start), 'mm') & ' mins early',...etc

topic Date Time Diff / If statement in QlikView

Date Time Diff / If statement

Re: Date Time Diff / If statement