Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Tavas
Contributor II
Contributor II

1:N Relationship (Map Visualization)

Hi everyone, thanks in advance for any help you can give me regarding this matter.

I have a table (Table A) with 5 columns and 2 of these columns have a 1:N relationship. For example:

NO  Norway   -
01   Name 1   NO
02   Name 2   NO
03   Name 3   NO

What I would like to with this table is to display it on a map and be able to select the country "Norway" and automatically the divisions (01, 02, 03) are displayed. If I click on the division 01, it will show me the subdivisions for 01 (001, 002, 003).

Is this even possible on QlikSense? If it is, how should I proceed?
If this is not possible, is there a similar solution to what I want?

Thanks!

Labels (2)
10 Replies
Tavas
Contributor II
Contributor II
Author

@Steven_Haught 

Thanks for your reply! In the meantime I was able to achieve what I wanted with a drill-down and calculated dimensions. Instead of using the full table, I had to "split it" using the Load Editor. 🙂