topic Re: Problem of selection in Scatter charts in QlikView

Problem of selection in Scatter charts

Thu, 11 Oct 2012 08:59:05 GMT

Hello ,

I am new to qlikview and i am currently working with scatter charts . Im plotting names of states against longitude and latitude and its working fine and showing me a rough map .

I have a list object box which contains the names of the states of a country, what i want is that whenever i select a state from the list box only that state needs to be highlighted in scatter chart rest every point needs to fade out ( have grey color ) . Also when i select a state from the list box only that states is shown on the scatter charts rest all the points are lost .

I want to retain every point on the chart irrespective of my selection by also want to highlight the state which i have selected from the list box .

Is there any way to achieve this?

. I am attaching the sample qvw file .

Thanks in advance

s_tushar

Re: Problem of selection in Scatter charts

Thu, 11 Oct 2012 15:03:52 GMT

See if this is what you are looking for.

Re: Problem of selection in Scatter charts

johnw — Thu, 11 Oct 2012 22:17:14 GMT

I think the attached is what you're asking for. I changed the expressions to use set analysis to always show every point. I then set the color of the point by adding a background color expression to the Longitude, which you can see if you click on the little + next to Longitude. If the color is set to null, it defaults to the colors on the Colors tab. Finally, I also set the grayed-out dots to be smaller than the selected dots by using a third expression in the chart. If there's confusion about how an if(LONGITUDE...) can work, the LONGITUDE will only have a value for the states you've selected. If the state is not selected, the LONGITUDE will be null, which is considered false.

Re: Problem of selection in Scatter charts

Fri, 12 Oct 2012 04:50:04 GMT

Hey John Witherspooon ,rebeccad thanks for your solution .both the solutions works well

Re: Problem of selection in Scatter charts

Fri, 12 Oct 2012 04:50:21 GMT

Hey John Witherspooon ,rebeccad thanks for your solution .both the solutions works well