Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Check this out and let me know if it helps: Set Analysis
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.