display averaged line graph with nullpoint reference
Hi,
I have a data set as shown in the attached screen capture with car speeds, for different brands, temperatures and elevations.
I want to display a graph of the car speed per brand, as a function of the temperature, and averaged over the elevation.
That's quite easy, and is the first graph in the screen capture.
(graph wizard with as first dimension the temperature, second dimension is the car, and the expression is Avg(Car speed))
Now I want to make a similar graph, but with a "fixed nullpoint" for all graphs. To verify in my example that even though the absolute maximum speed of the Lada is lower, it holds up better under increasing temperature compared to the Ferrari and Porsche.
In this graph, all points displayed, are divided by the value at 20°C of the specific brand, so that the value at 20°C is always 1.
That is the second graph in the screen capture, but seems to be more difficult to achieve in QlikView.
I would like this to work flexibly with selections as well, so that when I select a specific elevation, the value at 20°C is still fixed at 1.
(this means that dividing each value per car brand by a specific fixed value -as I did in my Excel- doesn't work, because if I would then subselect a specific elevation, my 20°C value would no longer be 1)
