Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Basic Question; Timestamps and Binning Time

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,

A

1 Reply
MarcoWedel

Hi,

try with

Timestamp(Round(created, 1/1440))

instead of

minute(created)

QlikCommunity_Thread_131019_Pic1.JPG.jpg

QlikCommunity_Thread_131019_Pic2.JPG.jpg

hope this helps

regards

Marco