Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.