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
