topic Re: scatter chart in QlikView

scatter chart

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

Hi friends ,

I was strucked in creating an scatter chart using the following data.In this data location A is coming twice based on the last seen time.so now how i want to show my chart is x-axis as Location , for each location it should show the last seen time as a bubble and when it comes to location A it should show the two bubbles.

When i tried to create this but i am not able to acheive.

Item	Location	LastSeen time
Item 1	A	4-Jan
	B	8-Jan
	C	12-Jan
	D	16-Jan
	E	20-Jan
	A	25-Jan

How can I achieve this . Can anyone suggest me how to implement this.

Re: scatter chart

varshavig12 — Mon, 24 Oct 2016 06:58:38 GMT

Like this :

Re: scatter chart

varshavig12 — Mon, 24 Oct 2016 07:04:28 GMT

Try this:

Re: scatter chart

kumarkp412 — Mon, 24 Oct 2016 07:14:37 GMT

Hi Varsha Vig,

Thanks for your reply,

But what i am trying is in one location i need show it as one bubble with two different color.

Is it possible in scatter chart.

Thanks

Kumar KVP

Re: scatter chart

varshavig12 — Mon, 24 Oct 2016 10:49:08 GMT

Recipe for a Scatter Chart

Creating a Scatter Chart

Re: scatter chart

HirisH_V7 — Mon, 24 Oct 2016 11:29:54 GMT

Hi,

is this what your'e looking for,

using this in Background color,

=IF(Aggr(Count(Date),Location)>1,LightRed(),LightBlue())

Else please elaborate your'e requirement.

-Hirish

Re: scatter chart

kumarkp412 — Mon, 24 Oct 2016 12:47:37 GMT

Hi Hirish,

Thanks for your reply. Appricate of your example.

Actually, my requirement is I am having one image(image consists of blue print of building 1st floor , floor contains the locations(A,B,C,D,E) ) .So now i am going to plot a bubble or bubbles in the location it to show the date timestamps .

i.e if they are more than one timestamps for a particular location. I want to show the more than one timestamp as bubbles in that location.

So thay why i am trying to have the no of bubbles in particular location.

I am having one more doubt on it is like I can able to show the bubbles in the location.

And also I am not fixed to one chart.If possible it can be done by another chart it is okay for me.

The bleow are the sample data with xy coordinates.Here the coordinate i have take as a sample.

Item	Location	DTTime	x	y
Item1	A	1/3/16 1:00	50	50
Item1	B	1/5/16 2:00	20	20
Item1	C	1/7/16 3:00	30	30
Item1	D	1/9/16 0:00	40	40
Item1	E	1/9/16 1:00	35	35
Item1	A	1/13/16 1:00	50	50

Please help me out or give me some suggestion on it.

Thanks

Kumar KVP

Re: scatter chart

Thu, 02 Mar 2017 14:57:53 GMT

Hi Varsha,

I'm also having the same problem as Kumar.

Unfortunately, I'm currently using the version of Qlikview that doesn't allow me to open up Qlikview files that were not created in my laptop. I believe your 86.qvw file would be able to illustrate the answer to me but I cannot open it.

Are you able to put in words what you actually did in the "Dimensions" & "Expressions" tab that enabled you to produce the scatter chart as shown in your message dated 24th Oct 2016 0258 hrs?

Alternatively, are you able to take screenshots and post it here?

Thanks

Lawrence