Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I guess it is possible with a little complexity.
Can you share some sample data.
Check this out.
I'm unable to open your .qvw, could you screenshot your solution?
Ben
Table:
Dimension:
Expression:
Script: