Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.