Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
benvatvandata
Partner - Creator II
Partner - Creator II

Multiple Summaries by Months, YTD, and Prior Years

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

4 Replies
neelamsaroha157
Specialist II
Specialist II

I guess it is possible with a little complexity.

Can you share some sample data.

neelamsaroha157
Specialist II
Specialist II

Check this out.

benvatvandata
Partner - Creator II
Partner - Creator II
Author

I'm unable to open your .qvw, could you screenshot your solution?

Ben

neelamsaroha157
Specialist II
Specialist II

Table:

Capture.PNG

Dimension:

Capture1.PNG

Expression:

Capture2.PNG

Script:

Capture3.PNG