topic Re: Line Graph over two different time series in QlikView

Line Graph over two different time series

Mon, 11 Mar 2013 15:27:54 GMT

Hi -

I am trying to create a simple line graph with two sets of data. For example, I have a customer table, that has the Membership Date. So I want one line graph to show the number of Customers growing. I have a second table called Purchases which has a column Purchase Date. So on the same graph, I want another line showing the number of Purchases growing.

The problem I have is that the line graph is only using one set of dates for the Y-axis. I don't know how to associate # of Purchaes to Purchase Date and # of Customers to Membership Date.

I have created an example attached.

Thanks!

Re: Line Graph over two different time series

Gysbert_Wassenaar — Mon, 11 Mar 2013 15:33:02 GMT

Is giving the date fields the same name an option? See attached qvw

Re: Line Graph over two different time series

Anonymous — Mon, 11 Mar 2013 15:34:15 GMT

Why can't you use one date for both? See attached.

Re: Line Graph over two different time series

Mon, 11 Mar 2013 15:40:09 GMT

This is a great idea, but in my larger data set, it will create a join on this column which will cause other data issues.

Re: Line Graph over two different time series

Mon, 11 Mar 2013 15:42:09 GMT

Thanks for the reply. Your sample gave me a "failed to open" error. Can you explain your solution?

Re: Line Graph over two different time series

Anonymous — Mon, 11 Mar 2013 15:48:35 GMT

It was exactly the same as form Gysbert 🙂

See another one, using Date as island. In case you canot open it:

Script addition

Date:

LOAD Series1Date as Date RESIDENT Series1;
LOAD Series2Date as Date RESIDENT Series2;

Chart is using Date as dimension, and eaxpressions are

Count(if(Series1Date=Date, Series1Value))

Count(if(Series2Date=Date, Series2Value))

Re: Line Graph over two different time series

Mon, 11 Mar 2013 16:12:23 GMT

This definitely works, but it creates a join between those two tables that causes other data issues. The search continues....

Re: Line Graph over two different time series

Anonymous — Mon, 11 Mar 2013 16:18:17 GMT

No, there is no join at all here. Did you open my 2nd example?