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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Aggregating data on

Dear All,

I am looking to calculate average temperature data based on the attached data series. What I have is 2 columns - one with time, other with Temperature (for every 5 minutes). The data is something like below:

   

TimeTemp
10:05:0049
10:10:0044
10:15:0043
10:20:0046
10:25:0045
10:30:0040
10:35:0050
10:40:0042
10:45:0043

I have uploaded this data in the Qlikview directly from a website API. as per the second step, I would want to get average temperature for 4 time periods as below:

   

TimeTemperature (Degree)
10:05

45.50

10:2544.25
10:45

45.50

2 Replies
antoniotiman
Master III
Master III

Hi Anand,

may be

Temp:
LOAD *,Autonumber(Floor((RowNo()-1)/4)) as A1 Inline [
Time Temp
10:05:00 49
10:10:00 44
10:15:00 43
10:20:00 46
10:25:00 45
10:30:00 40
10:35:00 50
10:40:00 42
10:45:00 43
]
(delimiter is spaces);

LOAD Time(Min(Time)) as Time,Avg(Temp) as Temp
Resident Temp
Group By A1;
Drop Table Temp;

Regards,

Antonio

Anonymous
Not applicable
Author

Apologies for coming back late on this. Thanks you very much Antonio. this was very very helpful.