Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andymayo
Contributor III
Contributor III

Dimension Restriction in A Bubble Dimension

Hi

 I have a scater plot with a dimension of Employee, I have the following measures

x-axis Last Scan Max(ScanTime)

y-axis First Scan  Min(ScanTime0

I have a size of Count(ScanTime)

I want to restirct the Bubbles to only show Employees who have had inexcess of 50 scans. When I do

If(Count(ScanTime) > '50',Employee)

I get invalid dimension....I have tried numerous thing and I cannot restrict it to remove these Employees. Can someone help? Thanks

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Can you try this instead

Aggr(If(Count(ScanTime) > 50, Employee), Employee)

 

View solution in original post

2 Replies
sunny_talwar

Can you try this instead

Aggr(If(Count(ScanTime) > 50, Employee), Employee)

 

andymayo
Contributor III
Contributor III
Author

Perfect, thanks