topic Re: Creating graph with 2 axis from multiple data sets in QlikView

Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 14:38:20 GMT

Hi,

In this scenario, I have 3 tables:

SQL SELECT DATE,

UNIQUEID,

RESULT

FROM TABLE1;

SQL SELECT DATE,

UNIQUEID

FROM TABLE2;

SQL SELECT,

UNIQUEID,

VALUE

FROM TABLE3;

These three tables contain values that are shared, the UNIQUEID is shared between all three tables and the DATE is shared between TABLE1 and TABLE2.

I want to plot a graph, that shows the RESULT from TABLE1 and the VALUE from TABLE3, but ONLY for those UNIQUEIDs that are in TABLE2. I assumed I needed to do some sort of JOIN first... But I'm not too certain. The graph should have 2 axis since the numerical value obtained from RESULT and VALUE would need their own respective scales.

Thank you in advance!

Re: Creating graph with 2 axis from multiple data sets

Nicole-Smith — Thu, 05 Sep 2013 14:46:12 GMT

You don't need to manually do any type of linking. If the fields are named the same in each table, QlikView will automatically link them. If you want to make sure, look at the table viewer (CTRL+T) and you should see that all of your tables are linked by those fields.

Also, if the same fields are used in the tables, QlikView will automatically combine the two tables together so that they become just one table, so for your first two tables, this will most likely be the case.

Re: Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 14:52:53 GMT

Yes, I see that they are linked. However, when I try to have 2 axis (by going into Axes > Position and change one to Right(Top)), the graph doesn't render the first expression properly anymore. When the graph from the first expression will have multiple y values per x value, whilst the 2nd expression will be 1 to 1. The table would end up looking something like this:

TABLE1:

Date UniqueID Result

8/5/13 100 44

9/5/13 123 55

TABLE2:

Date UniqueID

9/5/13 123

TABLE3:

UniqueID Value

123 7

123 8

123 7.5

Re: Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 18:38:13 GMT

Here's an attached file with the scenario I outlined. Any help would be appreciated!

Re: Re: Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 19:02:43 GMT

I don't quite understand your question but attached is your graph plotted using 2 axis.

I hope this helps.... a little!

Re: Re: Re: Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 19:10:08 GMT

Hi, Thanks for the reply

Let me try to clarify. I've attached a file to show what I would be looking for at the end.

Re: Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 19:16:15 GMT

I am assuming your Y axis is Value & Results. What is your X axis?

Re: Re: Re: Re: Creating graph with 2 axis from multiple data sets

Thu, 05 Sep 2013 19:18:24 GMT

This is using Date as your X axis....