topic Re: Plotting current quarter vs. same quarter from last year's values in App Development

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

mcQlikin — Fri, 24 May 2019 15:38:31 GMT

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

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

Wlad_Masi — Thu, 20 Jun 2019 21:20:47 GMT

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

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

mcQlikin — Fri, 21 Jun 2019 15:47:55 GMT

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.