3 Replies Latest reply: Mar 14, 2016 10:45 AM by Gysbert Wassenaar RSS

    Year on year line chart

    Matt Patterson

      how can i create a year on year line chart?

       

      what is meant to be simple is always a mess about in qlikview!!

       

      Data

       

      Agroup

      group1

      group2

      group3

      etc

       

      Yearperiod

      201510

      201511

      201512

      201601

      201602

      201603

      etc

       

      and quantity

       

       

      what i want is months along the bottom, quantity up the side and then a line for each year (goes back to 2006 so will need to be dynamic)

       

      like this

        • Re: Year on year line chart
          Gysbert Wassenaar

          Yes, tableau is more convenient with date fields in this regard. In Qlikview you should create month and year fields from your date first. Those fields you can then use as dimensions in your chart.

           

          MyData:

          LOAD

               Agroup,

               Year(Date) as Year,

               Month(Date) as Month

          FROM

               ...etc

               ;

           

          That's the best way. Alternatively you can create calculated dimensions in the UI using the same expression Year(Date) and Month(Date)