4 Replies Latest reply: Jun 9, 2017 10:54 AM by neelam sehrawat RSS

    Multiple Summaries by Months, YTD, and Prior Years

    Ben VanderLaan

      Hi,

       

      I've attached an excel spreadsheet with what I would like my qlikview chart to display, and I've also attached a picture of what I've already done - I'm using a pivot table with Month([QA Report Date]) as the dimension, and a few different summaries of fields as expressions... I'm just wondering if it's even possible to have a YTD column and previous years columns, along with the month columns I already have?

       

      This seems like it will be extremely difficult to do (if it's even possible), so my thoughts were I would just have to create more than one chart? (It is preferred that no scripting be added).

       

      Any help is appreciated.

       

      Thanks,

      Ben