Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
mcQlikin
Contributor
Contributor

Plotting current quarter vs. same quarter from last year's values

Hi Qlik Sense community, hoping to plot data quarterly vs from same quarter last year (see attached pic), for each Department, and select values in Category. For example, for Department value "AA", I'd like to plot this for Category "Claims". 

What's the best way to do this?

Department

Date

Category

Data

AA

12/31/2016

Claims

xxx

AA

3/31/2017

Claims

xxx

AA

6/30/2017

Claims

xxx

AA

9/30/2017

Claims

Xxx

AA

12/31/2017

Claims

xxx

AA

3/31/2018

Claims

xxx

BB

12/31/2016

Claims

xxx

BB

3/31/2017

Claims

xxx

BB

6/30/2017

Claims

xxx

BB

9/30/2017

Claims

xxx

BB

12/31/2017

Claims

xxx

BB

3/31/2018

Claims

xxx

2 Replies
Wlad_Masi
Former Employee
Former Employee

Check this out and let me know if it helps: Set Analysis

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
mcQlikin
Contributor
Contributor
Author

Thank you for linking this. I believe it would work for a simpler dataset. For the one i'm working with, it adds more complexity where we need to basically recognize and separate the dataset for a particular department, per certain category. 

I did end up figuring out a solution via the script editor, but did not end up using it since it involved creating about 50 separate tables (per department, per category). To date, still haven't figured out a good expression, we just used a more manual solution.