20 Replies Latest reply: Sep 2, 2016 7:18 AM by Vineeth Pujari RSS

    Logic help needed

    Learn Qlikview

      I have below data set.

       

      IDSubIDActual
      11100
      12200
      13250
      22300
      23400
      33500
      34600

       

      Output needed (I want to calculate it in front end only)

       

      IDValue
      10
      2200
      3

      400

       

      Logic: For ID 2, I want to see previous ID & subid should be equal to current id

                example, For ID 2, I will see the previous ID 1 and Pick subid =2 value