Solved: Re: How to create Comparision Charts by time? - Qlik Community

Report Inappropriate Content · ‎2015-07-09

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.

Report Inappropriate Content · ‎2015-07-24

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)

Clear enough?

View solution in original post

jagan · ‎2015-07-10

Hi,

Can you attach sample data and let us know your expected output with some screenshot.

Regards,

Jagan.

mikkeltaylor · ‎2015-07-10

‌Hi,

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!

mike

petter · ‎2015-07-11

Is it something like this you had in mind?

I have attached the Qlik Sense application that demonstrates this.

Report Inappropriate Content · ‎2015-07-13

how do i upload a file?

Report Inappropriate Content · ‎2015-07-13

Seems like what I want. How do I download the app?

petter · ‎2015-07-13

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.

Report Inappropriate Content · ‎2015-07-13

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.

stevedark · ‎2015-07-13

I've yet to create a Sense example of the same, but this QlikView app may give you some pointers on prior period comparisons:

QlikView App: Set Analysis - Prior Period Comparison

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.

Steve

Report Inappropriate Content · ‎2015-07-14

I think that this extension might help you: Compare Period Chart