Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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