Scatter plot over time

Tue, 08 Apr 2014 16:23:49 GMT

Hi,

I have the data below and I would like to understand how to make a scatter plot with the X axis showing time (with the ability to cycle through hours & minutes) and the Y axis showing Time in MicroSeconds. I have millions of rows so I imagine I will see a lot of dots on my screen. Can anyone help? Below is my load script and attached is the sample data.

LOAD

date(date#(mid(@2 2, 20), 'DD/MMM/YYYY:hh:mm:ss'), 'DD/MMM/YYYY hh:mm:ss') as [Creation Date Time GMT],

date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm'), 'DD/MMM/YYYY hh:mm') as [Creation Date GMT],

Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'MMM-DD')) as [Date PDT],

Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'YYYY')) as [Year PDT],

Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'MMM')) as [Month PDT],

Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'DD')) as [Day PDT],

Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'hh')) as [Hour PDT],

Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'mm')) as [Minute PDT],

@1 as [Remote Host],

@2 as [Request Time],

@3 as [Size],

@4 as [Time in Microseconds],

topic Scatter plot over time in QlikView

Scatter plot over time