topic Re: Make Scatterplot show selection and grey other values in QlikView

Make Scatterplot show selection and grey other values

proctors — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to do the following, but not with a line chart.

https://community.qlikview.com/blogs/qlikviewdesignblog/2014/02/07/line-chart-tricks-part-two#‌

Ishiness (or Keeping an Overall Sense of Where You Are in the Data Space)

I want all of the other values except what I'm selecting to be greyed out, and to highlight what I selected. When I click on a Clinician's name, all of the other values disappear.

Dimension: Clinician Name

Expression 1: Provider FTE = [YTD Avg]

Expression 2: Total RVUs = Sum({1} [RVU WORK])

Re: Make Scatterplot show selection and grey other values

andrei_delta — Mon, 11 Sep 2017 21:18:58 GMT

Hello,

put the color expression from the article which is:

if(isnull(only([Store Name])) ,ARGB(20,200,200,200),ARGB(190,43, 123, 70))

into background color for the first expression

Hope it helps,

Andrei

Re: Make Scatterplot show selection and grey other values

andrei_delta — Tue, 12 Sep 2017 07:57:11 GMT

This is how it looks at me

Re: Make Scatterplot show selection and grey other values

proctors — Tue, 12 Sep 2017 12:35:01 GMT

Ok, that made the colors uniform, however all other values disappear when I make a selection to look at a single employee's data compared to everyone else's.

Re: Make Scatterplot show selection and grey other values

andrei_delta — Tue, 12 Sep 2017 12:42:31 GMT

you have to put the set analysis in your expressions as well

for example: sum( {<UsedDimension=>} Qty) . you have to put the set analysis in every expression for the visual to work.

"UsedDimension=" in set analysis means it ignores the selections made on the UsedDimension and that's how the values are remaining on the scatterplot

Re: Make Scatterplot show selection and grey other values

proctors — Tue, 12 Sep 2017 13:05:29 GMT

I'm still missing something, which may be very obvious.

Expression1: sum( {1<[Clinician Name]=>} [YTD Avg]) (tried with and without the 1)

Expression2: Sum({1<[Clinician Name]=>}[RVU WORK])

Making a selection still makes all of the values except what I selected disappear.

Re: Make Scatterplot show selection and grey other values

andrei_delta — Tue, 12 Sep 2017 13:11:15 GMT

you put the [Clinician Name] field in the color expression? like in my exemple:

if(isnull(only([Store Name])) ,ARGB(20,200,200,200),ARGB(190,43, 123, 70))

you put [Clinician Name] instead of [Store Name].

Re: Make Scatterplot show selection and grey other values

proctors — Tue, 12 Sep 2017 13:20:09 GMT

Yup.

if(isnull(only([Clinician Name])) ,ARGB(20,200,200,200),ARGB(190,43, 123, 70))

Re: Make Scatterplot show selection and grey other values

andrei_delta — Tue, 12 Sep 2017 13:23:25 GMT

can you share the qvw?

Re: Make Scatterplot show selection and grey other values

proctors — Tue, 12 Sep 2017 13:30:45 GMT

I found it, the colors of the dots was very light and could not see on my screen. Thanks for your help!

Re: Make Scatterplot show selection and grey other values

andrei_delta — Tue, 12 Sep 2017 13:32:51 GMT

with pleasure!

Have a great day!

Andrei