Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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
Here's an attached file with the scenario I outlined. Any help would be appreciated!
I don't quite understand your question but attached is your graph plotted using 2 axis.
I hope this helps.... a little!
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.
I am assuming your Y axis is Value & Results. What is your X axis?
This is using Date as your X axis....