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 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. 🙂
