topic Re: Scatterplot Sorting in QlikView

Scatterplot Sorting

chrweber — Mon, 28 May 2018 07:42:11 GMT

Hi,

I have a scatterplot, that shows all values ( {1} ) and I Highlight the selection using Color and opacity.

However, I have yet to find a sorting order sat places the possible values before the background.

How can I achieve that.

Best Regards

Re: Scatterplot Sorting

MarcoWedel — Mon, 28 May 2018 22:45:33 GMT

can you show how the result should look like?

Re: Scatterplot Sorting

RonaldDoes — Tue, 29 May 2018 07:03:00 GMT

Hi Christoph,

You can use the "Sort by Expression" option and enter your expression without the {1} set.

Please find my attached example.

Hope this helps you.

With kind regards,

Ronald

Re: Scatterplot Sorting

chrweber — Tue, 29 May 2018 07:56:31 GMT

I am Well aware of that. But it is just that Expression i require.

All samples are always visible and only the possible are colored. The others are black. The transparency of colour and black samples can be adjusted.

But since I have thousands of samples it's highly possible that the black samples overlap the coloured samples especially if I want to display a single coloured sample.

vB API allows me to get only possible values the chart functions do not appear to provide the same functionality.

Best regards

Re: Scatterplot Sorting

RonaldDoes — Tue, 29 May 2018 08:03:49 GMT

Hi Christoph,

I'm pretty sure that using "Sort by Expression" with an expression containing just the "possible/colored" samples will sort them "on top" of the black samples, as in my demo.

That would meet your requirement, right?

With kind regards,

Ronald

Re: Scatterplot Sorting

chrweber — Tue, 29 May 2018 08:08:32 GMT

I'm on my phone right now but I will check once I'm on my laptop. Thank you very much