Scatter with Line chart in qlikview

[lawrance]

Hi,

Please help me how to do scatter with line chart in qlikview.

Please find the image for expected ouput, I got output from excel but i don't know in QlikView.

Thanks,

Lawrance. A

[marcus_sommer]

I don't think that's possible to build such chart but there might be other visualizations which are suitable for you. Maybe someone could help you further if you elaborate your task in more detail and provide a sample application.

- Marcus

[MarcoWedel]

please provide some sample data.

thanks

regards

Marco

[lawrance]

Hi,

Please find the sample data.

Request Type	TerminationTime	Meter ID	Execution Start	Execution End
Connect	5/24/2016 5:23	272241261	5/24/2016 5:23	5/24/2016 5:23
Connect	6/8/2016 16:34	270231175	6/8/2016 16:34	6/8/2016 16:34
Connect	6/17/2016 11:49	270504962	6/17/2016 11:49	6/17/2016 11:49
Connect	6/17/2016 11:49	270504962	6/17/2016 11:49	6/17/2016 11:49
Connect	6/28/2016 12:12	271989979	6/28/2016 12:12	6/28/2016 12:12
Connect	7/1/2016 22:43	271298080	7/1/2016 22:43	7/1/2016 22:43
Disconnect	7/7/2016 7:40	272129528	7/7/2016 7:40	7/7/2016 7:40
Disconnect	7/8/2016 3:19	272097754	7/8/2016 3:19	7/8/2016 3:19
Disconnect	7/18/2016 10:06	270786389	7/18/2016 10:06	7/18/2016 10:06
Disconnect	7/18/2016 11:54	270111226	7/18/2016 11:54	7/18/2016 11:54
Connect	7/20/2016 10:07	271202436	7/20/2016 10:07	7/20/2016 10:07
Disconnect	7/20/2016 15:00	242066709	7/20/2016 15:00	7/20/2016 15:00
Disconnect	7/21/2016 9:43	270502106	7/21/2016 9:43	7/21/2016 9:43
Disconnect	7/21/2016 11:23	272269202	7/21/2016 11:23	7/21/2016 11:23
Disconnect	7/22/2016 8:42	242066709	7/22/2016 8:42	7/22/2016 8:42
Disconnect	7/25/2016 15:54	270368490	7/25/2016 15:54	7/25/2016 15:54
Disconnect	7/25/2016 15:55	270368490	7/25/2016 15:55	7/25/2016 15:55
Connect	7/26/2016 11:34	271996971	7/26/2016 11:34	7/26/2016 11:34
Disconnect	7/27/2016 12:25	270907834	7/27/2016 12:25	7/27/2016 12:25

Thanks,

Lawrance. A

[MarcoWedel]

Can you describe how your sample data are to be interpreted to get the result you posted?

Maybe you can provide your Excel solution?

thanks

Marco

[lawrance · Accepted solution]

Hi all,

Thanks for your response and I got the output.

[MarcoWedel]

Hi,

I just was about to post this example when reading your solution:

table1:
LOAD *, Interval([Execution End]-[Execution Start]) as Duration;
LOAD *, Time(RangeMin(1,[Execution Start]+RangeMax('00:10',pow(Rand(),100)*(1-[Execution Start])))) as [Execution End];
LOAD *, Time(Match([Request Type],'Connects','Cut-Ins','Cut-Outs','Disconnects','MIs')/12+Rand()*(1-Match([Request Type],'Connects','Cut-Ins','Cut-Outs','Disconnects','MIs')/12)) as [Execution Start];
LOAD Pick(Ceil(Rand()*5),'Connects','Cut-Ins','Cut-Outs','Disconnects','MIs') as [Request Type],
    100000000+RecNo() as [Meter ID]
AutoGenerate 10000;

(Just creating some test data, the only relevant part here is the precalculation of the duration)

hope this helps nevertheless

regards

Marco

P.S.:

Can you post your solution as well for others to learn from?

thanks

[lawrance]

Thanks Wedel. It's really good work. This discussion I learned lot

[MarcoWedel]

You're welcome.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[lawrance]

How I can close the this thread. Please help me.