topic Re: Display diagonal line when only one point is selected in QlikView

Display diagonal line when only one point is selected

Wed, 25 Nov 2020 16:16:04 GMT

I have a graph like this:

This is my dimension tab:

This is my expression tab:

The third dimension is there to create the diagonal line (see the linear reference at the bottom left in my expression tab). I got the idea from here (Reference Line)!

When I select only one point in the graph the line disappears (see below). But I want it to remain there. Other solutions to display a diagonal line are welcome too. Thanks for the help!!

Re: Display diagonal line when only one point is selected

zhadrakas — Mon, 07 Nov 2016 12:19:17 GMT

Hello,

Try Sum({1} IST) instead of Sum(IST).

regards

Tim

Re: Display diagonal line when only one point is selected

Mon, 07 Nov 2016 12:42:16 GMT

Nice idea but unfortunately the not selected points stay in the graph (see below):

Re: Display diagonal line when only one point is selected

Mon, 21 Nov 2016 08:53:05 GMT

My workaround is to create a second scatter chart which will only show up when only one entity is selected. Then make the background of that scatter chart transparent and add a diagonal line object. You need also to fix the axis both to 100%.

Re: Display diagonal line when only one point is selected

Mon, 21 Nov 2016 08:57:45 GMT

There is also the possibility to make those points at the bottom transparent and then it will look like that it works. The only two drawbacks are the performance because the selection stays the same and the legend still shows the not selected points but in grey color.