Combine fields from two tables to set Chart's parameter

Thu, 11 Sep 2014 12:35:13 GMT

I have 2 tables like following.

Engine	Year	Temperature 1	Temperature 2
A	2011	-6	13
A	2012	-7	25
B	2011	-3	8
B	2012	-2	12

Position	Parameter
Position1	Temperature1
Position2	Temperature2

I am trying to make a bubble chart which would show the values of Temperature1 and Temperature2 separately on Y-axis. Bubble's color will represent Engine and bubbles wil animate in Y direction with the change in value of Temperatures with change in Year. So Year is the dimension that controls the animation and value of Temperatures are the ones which animate showing results for each Engine.

The problem here is that I want to set Position1 and Position2 as X-axis parameters? I want it like the picture attached here, so that behavior of both Temperatures can be visualized combined in one chart, but separated by a distance on X-axis.

At position1, values of Temperature1 should be shown on Y-axis for different Engines. Similarly, for Position2, values of Temperature2 should be seen.

Please help... Thanks in advance...!!!!

topic Combine fields from two tables to set Chart's parameter in QlikView

Combine fields from two tables to set Chart's parameter