6 Replies Latest reply: Feb 12, 2018 5:56 PM by Ric Morgan RSS

    Interval Function

    Ric Morgan

      Hi All,


      I'm creating some KPI's in Qlik Sense to show the total number of appointments that lasted a certain amount of time...


      I'm currently using this formula to calculate the interval of every appointment.


      =interval(date([End Time], 'hh:mm') - date([Start Time], 'hh:mm'), 'hh:mm')


      This gives me a combination of 30mins, 60mins, 90mins and 120 mins appointment lengths.


      How do I now create a KPI to display only the 30mins total? i.e. out of 80 appointments 5 lasted 30 mins.