Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Display all Dimension values in a map chart


My data sample is shown below.


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



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