3 Replies Latest reply: Oct 18, 2017 12:10 PM by I. Sorin Rusu RSS

    KPI Start- End

    Jordi Torras Carreño

      Hello Gurus,

       

      In QlikSense I have one table with the following fields (among others):

       

      [DateID] that is represented as DD/MM/AA hh:mm:ss

      [Date] that is represented as DD/MM/AA (extracted from DateID),

      [Month] that is represented as MM/AA (extracted from DateID),

      [Temperature] <-- I have one record for each [DateID]

       

      I would like to have the following calculations when selecting a [Month] or [Date] os [Date ID Range]:

       

      Start Temperature: Temperature in the beginning of the selected date

      Final Temperature: Temperature in the end of the selected date.

       

      How can I reach it?

       

      Thanks in advance.