Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr Embedded IFs

All,

I have a pretty lengthy If(Sum()) > then statement, that populates the variance of Hours Worked Over Target hours, So right now i have a straight table with that looks Something like example below. I want to create two text boxes that displays the Count(distinct [Employee Name] has a positive variance, and one that has a Count(Distinct( [Employee Name]) that has a negative variance. The variance formula is a pretty extensive formula. Any recommendations?

variance.png

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Sum (Aggr (If(YourVarianceExpression < 0, 1), [Employee Name]))

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Sum (Aggr (If(YourVarianceExpression < 0, 1), [Employee Name]))

Not applicable
Author

Yep that was it, Thanks Manish!