Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cbushey1
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?

Labels (1)
1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

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
Patric_Nordstrom
Employee
Employee

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

cbushey1
Creator III
Creator III
Author

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