2 Replies Latest reply: Dec 23, 2016 5:14 AM by vj kri RSS

    how to get actual difference b/w two rows in a same table

    Jithu J

      I would like to have a two date filters on same page . If I choose the dates then I would get the difference of price between those two dates.

       

      Ex :  Filters on page like FromDate  ToDate

      if the fromDate = 02-11-2016 and ToDate=17-11-2016

      Then I should the derived value as 39.6 i.e. 1091.1 - 1051.5

       

      Can anybody help on how to achieve this in qlik sense ???

         

      CompanyPriceDate
      5000021091.102-11-2016
      5000021087.6503-11-2016
      5000021085.0504-11-2016
      5000021088.308-11-2016
      5000021056.309-11-2016
      5000021065.5510-11-2016
      5000021066.9511-11-2016
      5000021051.517-11-2016
      5000021046.0518-11-2016
      500002106522-11-2016
      5000021062.5523-11-2016
      5000021055.7524-11-2016
      5000021057.425-11-2016
      5000021059.628-11-2016
      5000021055.629-11-2016
      5000021055.5501-12-2016
      5000021051.9502-12-2016
      5000021044.0505-12-2016
      5000021056.5508-12-2016
      5000021056.109-12-2016
      5000021046.713-12-2016
      5000021046.614-12-2016
      5000021051.7515-12-2016
      5000021058.416-12-2016
      5000021048.419-12-2016
      5000021029.2522-12-2016