We have daily sales total for last several quarters including the current quarter that is in progress.
How can I plot overlay line charts by choosing two Quarters.
e.g. last Quarter (Q1) has 90 days. So one line with 90 data points.
and current quarter (Q2) has so far 30 days work of sales avalable....so a partial line with 30 data points. This will be overlayed on Q1 line chart.
Solved! Go to Solution.
1) In your browser, navigate to KFredberg/Compare-Period-Chart · GitHub
This link will redirect you to the "Compare Period Chart" extension's repository.
2) You will have to download the extension as a ZIP file, so you will need to click on the "Download ZIP" button (the picture below indicates that button).
3) After you've finished installing the ZIP file, you will have to extract it: right click on the file and click on "extract here"(or something similar).
4) To proceed, you will need to watch this video, it will teach you how to install extensions: Qlik Sense - Introduction to Extensions (video)
I don't think you can with the out of the box charts. I tried this yesterday , as I was looking to plot goals scored by football team over time. I managed to find a chart within the D3 extension charts that did the trick, although the lines are curbed, so not straight.
for your example you will probably need your time dimension to be a day number of the quarter I.e 1-90 to be able to then overlay the quarter field.
if anyone finds a better solution I'd also be interested!
You just click on the link that is named "Time overlap.qvf" and you will download it with your browser.
You will have to store it in your Qlik Sense Apps folder which should be located under
"My Documents\Qlik\Sense\Apps". Then you can launch it from Qlik Sense Desktop hub.
Got it. Very useful information.
In visualization, do you think there might be a way we can toggle between "days", "periods", "quarters"?
Some target audience are supposed to manage numbers on a daily bookings basis. So would be nice if end users are able to just click these options to render the visualizations by day, period or quarter.
Thanks so much for your help. Loving this tool already.
I've yet to create a Sense example of the same, but this QlikView app may give you some pointers on prior period comparisons:
The variables will need to be created in the load script, as there is no way to create them through the Sense Desktop environment. The expressions you will need to copy out of QlikView.