Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Line Graph over two different time series

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!

Tags (2)
7 Replies

Re: Line Graph over two different time series

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


talk is cheap, supply exceeds demand
mov
Esteemed Contributor III

Re: Line Graph over two different time series

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

Not applicable

Re: Line Graph over two different time series

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.

Not applicable

Re: Line Graph over two different time series

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

mov
Esteemed Contributor III

Re: Line Graph over two different time series

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=DateSeries1Value))

Count(if(Series2Date=DateSeries2Value))

Not applicable

Re: Line Graph over two different time series

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

mov
Esteemed Contributor III

Re: Line Graph over two different time series

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

Community Browser