Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Display all Dimension values in a map chart

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