Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
benvatvandata
New Contributor III

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
Valued Contributor II

Re: Multiple Summaries by Months, YTD, and Prior Years

I guess it is possible with a little complexity.

Can you share some sample data.

neelamsaroha157
Valued Contributor II

Re: Multiple Summaries by Months, YTD, and Prior Years

Check this out.

benvatvandata
New Contributor III

Re: Multiple Summaries by Months, YTD, and Prior Years

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

Ben

neelamsaroha157
Valued Contributor II

Re: Multiple Summaries by Months, YTD, and Prior Years

Table:

Capture.PNG

Dimension:

Capture1.PNG

Expression:

Capture2.PNG

Script:

Capture3.PNG

Community Browser