Limiting number of displayed dimensions - plotting elevation from GPS

Anonymous — Tue, 10 Jun 2014 10:55:13 GMT

I am in the process of learning QlikView and have loaded in some data from my Garmin GPS which I use whilst cycling to "play" around with. I am trying to create a graph to plot the elevation during each ride. Every second the Garmin takes a note of the current location (lat and lon), heart rate, cadence, temperature and elevation. Assuming a ride of two hours, that's 7200 data points of elevation. Obviously that is a bit excessive to plot on a chart so I was open to ideas on how this may be achieved. Is there a way to perhaps only plot the elevation points but only display some of the time points to keep the chart tidy?

My thanks in advance for any input. Greatly appreciated.

Re: Limiting number of displayed dimensions - plotting elevation from GPS

whiteline — Tue, 10 Jun 2014 13:21:57 GMT

Hi.

Use the aggregation.

You can create time dimention that has minutes (without seconds) corresponding to your timestamps.

Then you can use sum/Avg/Count aggregation functions depending on the nature of data to plot the chart.

topic Re: Limiting number of displayed dimensions - plotting elevation from GPS in QlikView

Limiting number of displayed dimensions - plotting elevation from GPS

Re: Limiting number of displayed dimensions - plotting elevation from GPS