Hi,
My data sample is shown below.
Sheet_1
Date Site_Code Alarm
1/2/19 A high_temp
1/2/19 B high_temp
1/2/19 C door_open
2/2/19 A high_temp
2/2/19 B door_open
3/2/19 A high_temp
4/2/19 A high_temp
4/2/19 B door_open
4/2/19 C high_temp
Sheet_2
Site_Code Latitude Longitude
A -5 5
B -6 6
C -7 7
D -8 8
E -9 9
Sheet_1 and Sheet_2 are associated. I have 3 filter panes of Date, Alarm and Site_Code. When I create a Map, I don't seem to get all the 5 Site_codes (A, B, C, D, E). I am only getting site_codes with alarms. How do I get qlik sense to dispaly all site_code values despite whether it had an alarm on a particular date or note. Even when one filters using Alarm, I would still need to see all the sites(those that have the alarm and those that don't have).
Kindly assist
