Hi Qlik Community,
I'm new to Qlik Sense, and I'm trying to have an app in Qlik Sense with a map with 10 different locations, and I want to have the average measurement for a week of an air sensor attached on a belt of a technician on each locations.
I've got an excel file with 5 columns :
| Date | Thomas | site | latitude | longitude |
| 17/12/2020 07:00 | 14,32 | alpha | 45.656058 | 7.960095 |
| 17/12/2020 07:01 | 14,39 | alpha | 45.656058 | 7.960095 |
| 17/12/2020 07:02 | 14,46 | alpha | 45.656058 | 7.960095 |
This sheet has multiples lines, with 10 different locations, and a measurement every minutes on 5 days.
- 2 problems :
=> I've got a message on the map, when I edit it, that says that it's a limited view of my data due to not valid geographical forms : I don't know what to do in this case
=> I didn't find the way to have these average measurements for a week per site, in a "points layer" map, where the points color are linked with these average numbers
Thanks for your help
Regards
Nico
