topic Re: Time Series with Different Times in QlikView

Time Series with Different Times

Wed, 29 May 2013 01:56:46 GMT

hi all,

I searched the forum for a solution to the following question with no luck...

Can someone show me how to make a time series line graph with two different date values on the x axis. I would like to see the sum of the payment and the invoice transactions across the different dates. excel file is attached.

thank you so much for your help!

Re: Time Series with Different Times

Gysbert_Wassenaar — Wed, 29 May 2013 06:21:00 GMT

See attached example

edit: Press the Clear button to clear the selection in the Date listbox.

Re: Time Series with Different Times

Wed, 29 May 2013 14:43:52 GMT

Thanks for your help! One question though - why is the x axis cut off in April though? The data should run through December.

Re: Time Series with Different Times

Wed, 29 May 2013 15:38:27 GMT

Thanks! that works and the full chart is shown but I'm a bit confused by the "date" field that you created. Is it the payment date or the invoice date or a whole new date?

Re: Time Series with Different Times

Gysbert_Wassenaar — Wed, 29 May 2013 16:07:31 GMT

It's the payment date for the payments and the invoice date for the invoices.

Re: Time Series with Different Times

Wed, 29 May 2013 18:23:57 GMT

Sorry - I'm still confused. I only see "date" as the dimension - how can both the payment and the invoice date be the x axis without a calculated dimension?

Thanks for your patience - just trying to follow along on your approach!