topic Re: How to combine several timeseries data to a single point in time. in QlikView

How to combine several timeseries data to a single point in time.

jleefjcapital — Thu, 21 May 2015 10:56:18 GMT

Hello,

I'm working with several timeseries data that I would like to combine on a single date to create a cross-sectional view of the data on a bar chart for instance or a scatter plot.

Does anyone know how to do this?

Thank you,

Jessica

Re: How to combine several timeseries data to a single point in time.

rakesh_kumar — Thu, 21 May 2015 11:28:35 GMT

Hi Jes,

Please could you attach a sample app with some data, so I can have a look and suggest a solution?

Regards,

Re: How to combine several timeseries data to a single point in time.

jleefjcapital — Thu, 21 May 2015 11:31:24 GMT

Yes, but do you know how to save and send these workbooks? I haven't been able to figure this out yet. Thank you!

Re: How to combine several timeseries data to a single point in time.

fvelascog72 — Thu, 21 May 2015 11:32:46 GMT

Hi,

It´s sounds like if you need a Master Calendar. You can find several examples searching in this forum.

Re: How to combine several timeseries data to a single point in time.

jleefjcapital — Thu, 21 May 2015 11:44:55 GMT

I'm not sure if that's what I need. I have three timeseries for GDP data by state that I would like to view for only the most current period across the states in a bar chart. Is there a way to combine the three series and truncate the data to a single date?

Thank you,

Jessica

Re: How to combine several timeseries data to a single point in time.

fvelascog72 — Thu, 21 May 2015 11:48:25 GMT

Now this sounds like you need a Canonical Calendar.

Re: How to combine several timeseries data to a single point in time.

rakesh_kumar — Thu, 21 May 2015 11:57:48 GMT

Hi Jes,

You can click on File---> Save as with 'Test.QVW' on desktop or other location where you prefer and then you can reply to this thread by clicking on advanced Editor link where you will be able to upload the Test.QVW file by opening the location in the dialog box and click on reply, so it will be posted.

Also if the file size is massive, then you can create any list box on any field like date or month and select few values and then go to File---> Reduce data----> Keep possible values and save as Test.QVW and it will have less file size and easy to upload as well.

Regards,

Re: How to combine several timeseries data to a single point in time.

jleefjcapital — Thu, 21 May 2015 12:12:35 GMT

It turned out to be much simplier- I just plotted all of the series onto a bar graph and filtered by date....:) Thank you.

Re: How to combine several timeseries data to a single point in time.

rakesh_kumar — Thu, 21 May 2015 13:01:39 GMT

Hi Jes,

That's good, also this link gives you more detailed understanding of the process.

Canonical Date

Regards,