topic Aggregating data on in QlikView

Aggregating data on

Anonymous — Wed, 07 Jun 2017 12:35:00 GMT

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:

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

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:

Time	Temperature (Degree)
10:05	45.50
10:25	44.25
10:45	45.50

Re: Aggregating data on

antoniotiman — Wed, 07 Jun 2017 15:32:22 GMT

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

Re: Aggregating data on

Anonymous — Tue, 04 Jul 2017 15:41:52 GMT

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