7 Replies Latest reply: Jun 12, 2013 9:32 PM by Jihan Wang RSS

    Segmented Average Lines in Chart

    Jihan Wang

      Hello,

       

      I am pretty new with QlikView and now developing some dashboard for my organization. Currently, the line chart has total sale by month-year for 3 years and I would like to add an line for average sale. This average line is not the grand average across all years. For each year, the average line is the average for that year. For example, from Jan-2010 to Dec-2010, the average line is the average value for Year 2010, and from Jan-2011 to Dec-2011, the line is the average for Year 2011. Is there a way to do it. I assume this can be done with set analysis? But can someone let me know what would be the correct expression?

       

      Thank you so much!