topic Re: Basic Question; Timestamps and Binning Time in QlikView

Basic Question; Timestamps and Binning Time

Wed, 27 Aug 2014 16:54:48 GMT

Hi there,

Yet another Qlikview basic question - my third today! Thanks again for all the help so far.

I am trying to display a count over time, binned by minutes. My data is called 'created' and is in the format DATE then TIME, i.e. 02/04/2014 15:35:57

I have tried applying 'minute(created) but only get the attached picture, and looking through the Qlik forums finds problems far more difficult than mine!

Thanks again,

Re: Basic Question; Timestamps and Binning Time

MarcoWedel — Thu, 28 Aug 2014 00:32:57 GMT

Hi,

try with

Timestamp(Round(created, 1/1440))

instead of

minute(created)

hope this helps

regards

Marco