Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Raju_6952
Creator II
Creator II

Qlik sense map extension auto filtering

Hi,

 

I have a requirement in qlik sense like i have fields like country,state,city and region, when I click on country filter it should filter to states automatically in qlik sense map extension by using hierarchy group.

Note: not using drill down analysis 

 

Any suggestions would be highly appreciated.

 

Kind regards,

Raju

Labels (1)
2 Replies
pallavi_96
Partner - Contributor III
Partner - Contributor III

Hi,

Hi,

Although I'm unsure if my answer will be helpful to you, I'll nonetheless share it with you.

The following formula in dimension can be used in two area layers in same map.

1st Area Layer - 

=if(GetFieldSelections(Country),State,Country)  or if(GetSelectedCount(Country)>0,State,Country)

2nd Area Layer - 

=if(GetSelectedCount(State)>0,City,State)

 

 

 

Raju_6952
Creator II
Creator II
Author

Hi @pallavi_96 ,

 

Thank you for your inputs will check it out and let you know.

 

Regards,

Raju