Dynamic Reference Line in a scatter chart based on a variable

ficheral — Sat, 16 Nov 2024 20:29:49 GMT

Hello community,

I am facing a visualization problem.

I want to create a scatter chart where I have a measure 1 ( a variable aggregating a measure in a table) in the x axes and a measure 2 (a variable aggregating a measure in a table) in the y axes.

I want to show a reference line in the Y axes (in brown in the picture) being the average of measure 2 dynamically changing according the filtering in the dimension of the cycle group.

Further I want to show a reference line in the X axes (in red in the picture) being being the average of measure 1 dynamically changing according the filtering in the dimension of the cycle group.

I suspect that I could make use of AGGR function (since measure 1 and measure 2 are already aggregated variables) but cannot get the syntax right.

Can someone help me?

Re: Dynamic Reference Line in a scatter chart based on a variable

chrismarlow — Tue, 09 Jul 2019 19:28:00 GMT

Hi,

I think you are going to need to share more about the set up of your measures & your cyclical group/dimension, as I am guessing you have got to the point of enabling the reference lines?

Cheers,

Chris.

topic Re: Dynamic Reference Line in a scatter chart based on a variable in QlikView

Dynamic Reference Line in a scatter chart based on a variable

Re: Dynamic Reference Line in a scatter chart based on a variable