3 Replies Latest reply: Apr 18, 2017 6:00 AM by naveen kumar RSS

    how does show increase or decrease variation in qlikview

    naveen kumar

      Hello All,

                     i need to show % increase or % decrease Variation  between quarters

      let say i got

      Year        Quarters       value

      2017           q1                   200

      2017          q1                  100

      2017              q1                300

      2017            q2              100

      2017           q2                  200

      2017              q2               300

      .............

      .......................................

      so on till quarter 4 i  got data

       

      i expression like this

      q1 q2-q1 %  q3-q2% q4-q3%

       

      so in line chart i will add

       

      dimension

      Quarters


      what Expression should i need to write ?



      Thanks