Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)