Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Raju_6952
Creator III
Creator III

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 III
Creator III
Author

Hi @pallavi_96 ,

 

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

 

Regards,

Raju