5 Replies Latest reply: Sep 19, 2011 6:45 AM by Jason Michaelides RSS

    Yearwise Data

      I have date and sales column in my DB. I want the sum(sales) in Yearwise. How to achieve it in Qlikview? Can anyone suggest me...

       

       

      Regards,

      Jeeva.

        • Yearwise Data
          Jason Michaelides

          Hi,

           

          In your load script, add a field:

           

          Year(Date) AS Year

           

          Then in the chart put Year as the dimension and Sum(Sales) as the expression.  You could also put Year(Date) as the dimension in the chart but it's better in the script.

           

          Hope this helps,

           

          Jason