topic Re: How to calculate daily average temperature? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-daily-average-temperature/m-p/429189#M1148234 <HTML><HEAD></HEAD><BODY><P>Best way is to start by splitting the datetime field into date and time fields in the script. Then you can either calculate the average in the script too or only in a chart. See attached example.</P></BODY></HTML> Fri, 31 May 2013 14:35:29 GMT Gysbert_Wassenaar 2013-05-31T14:35:29Z How to calculate daily average temperature? https://community.qlik.com/t5/QlikView/How-to-calculate-daily-average-temperature/m-p/429188#M1148233 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview users,</P><P></P><P>I have a dataset which consist of a hourly logging (per day) of the temperature outside.</P><P>I want to create a new temperature field called temperature_per_day which holds the daily temperature value.</P><P>How can I achieve this?</P><P></P><P>I added the dataset as an attachement.</P></BODY></HTML> Fri, 31 May 2013 14:08:30 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-daily-average-temperature/m-p/429188#M1148233 2013-05-31T14:08:30Z Re: How to calculate daily average temperature? https://community.qlik.com/t5/QlikView/How-to-calculate-daily-average-temperature/m-p/429189#M1148234 <HTML><HEAD></HEAD><BODY><P>Best way is to start by splitting the datetime field into date and time fields in the script. Then you can either calculate the average in the script too or only in a chart. See attached example.</P></BODY></HTML> Fri, 31 May 2013 14:35:29 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-daily-average-temperature/m-p/429189#M1148234 Gysbert_Wassenaar 2013-05-31T14:35:29Z