Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus.Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Display layer conditions

Hi there,

I want to control when a layer is shown on the map but I am not sure how to control that aside from using the restrict drill down field. I have a few area maps that this works well for going from State, to county to zip code, however I want to show a heat map only when the county layer is active. Since the heat map doesn't use the same dimension the others do I cant use the restrict drill down field. 

Any thoughts, or suggestions?

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Display layer conditions

Use count distinct to build up an expression.

For example

count(total  distinct country)=1 and count(total  distinct state)=1 and count(total  distinct county)>1

 to check if only one country, one state and several counties is selected.

Thanks,

Patric

View solution in original post

2 Replies
Highlighted
Employee
Employee

Re: Display layer conditions

Use count distinct to build up an expression.

For example

count(total  distinct country)=1 and count(total  distinct state)=1 and count(total  distinct county)>1

 to check if only one country, one state and several counties is selected.

Thanks,

Patric

View solution in original post

Highlighted
Creator III
Creator III

Re: Display layer conditions

Thanks I was missing the "=1" part of that formula.