1:N Relationship (Map Visualization)

[Tavas]

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!

[rwunderlich]

Will a Dimension drill-down group work for this scenario?

-Rob

[Tavas]

Hi Rob,
Thanks for the suggestion!

I tried to do so, but it's not working. Perhaps, I'm doing something wrong.

[Steven_Haught]

@Tavas 

As Rob Stated a drill down sounds like what you are trying to accomplish. Can you share a bit of the data set or the full five columns that you are working with, glad to help you set that up. Or even share how you have tried to set the drill down currently. 

[Tavas]

@Steven_Haught 

Thanks for reaching out!

I have attached a file with some sample data.

The drill-down I created is as follows:

=if(div_level = 2, div_name)
=if(div_level = 3, div_name)&', '&if(div_level = 2, div_name)

I was able to successfully obtain what I wanted by creating two separate files, one with level 2 names (Counties) and another one with level 3 names (Municipalities). However, I need to use a single file, so this is not a solution for me.

I appreciate any help you can give me as I'm very new to Qlik!

Best,

Soraia

[Steven_Haught]

@Tavas 

are Div_Level and Div_code items that you have assigned? 

[Tavas]

@Steven_Haught 

Yes, I assigned them. Div_Level is the level of granularity of the data and div_code are unique identifiers for each entry.

[Steven_Haught]

@Tavas 

I thought that might be the case.  Are you wanting to do an area layer or a point layer? 

[Tavas]

@Steven_Haught 

I want to do an area layer.

Thanks once again for your help!

[Steven_Haught]

@Tavas 

Since I am unfamilar with the admin layers of Norway can you help me understand the levels? Seems like you may need to do a dissolve of the assigned layers in order to do a proper drill down.