Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Timestamp to stop at minute

Hi all,

Im guessing this should be pretty quick fix for someone.

my data has a row for every 10 seconds (i.e 6 per minute).

what i want is to average those to minute values so what i did was in the load script the below

Time(SLO_Sim_Time,'hh:mm') as [Minute],

and then used Minute as the dimension.

this hasnt worked at all, i still have all 6 data points on my chart???

my current expression is =avg(Speed)

thanks for any help

1 Solution

Accepted Solutions
Employee
Employee

How about this:

time( maketime(  hour( Time(SLO_Sim_Time)) , minute(Time(SLO_Sim_Time))) , 'hh:mm' ) as Minute

View solution in original post

1 Reply
Employee
Employee

How about this:

time( maketime(  hour( Time(SLO_Sim_Time)) , minute(Time(SLO_Sim_Time))) , 'hh:mm' ) as Minute

View solution in original post