Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
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.