1 Reply Latest reply: Feb 24, 2016 12:21 PM by Gysbert Wassenaar RSS

    Compute index score inside measure

    Dennies Salenga

      Hi there, I'm new in qlik sense and i'm trying to build an app that shows a daily index scores. index score formula is (currentScore/PreviousScore)*100.  but my problem is i don't know how to get the previous data inside the measure. please help

       

      here's my sample data

       

      DayScoreBranch
      Sun80BR01
      Mon95BR02
      Tue70BR01
      Wed85BR02
      Thu95BR02
      Fri85BR01
      Sat80BR01
      Sun75BR02
      Mon85BR02
      Tue85BR01
      Wed70BR02
      Thu90BR01
      Fri75BR02
      Sat95BR01