Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
posywang
Creator
Creator

AGGR Question

​Please check the attached sample file. My goal is to hide resources that have allocation as 1 FTE but somehow Becky in example can't be hidden. Please help. Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Seems like the rounding issue

If(Round(Sum({<Version={'Planning Tool'}> } AssignedFTE), 0.0000000000001) = 1, 0, Sum({<Version={'Planning Tool'}> } AssignedFTE))


Capture.PNG

View solution in original post

5 Replies
mayankraoka
Specialist
Specialist

Hi Xia,

Please try below expression:

if(aggr( sum( {<Version={'Planning Tool'}> } AssignedFTE),Mth)=1,

0,

aggr(sum( {<Version={'Planning Tool'} > } AssignedFTE),Mth))

Regards,

Mayank

posywang
Creator
Creator
Author

It's not working...

It now shows 2.8 under Becky's name...

sunny_talwar

Seems like the rounding issue

If(Round(Sum({<Version={'Planning Tool'}> } AssignedFTE), 0.0000000000001) = 1, 0, Sum({<Version={'Planning Tool'}> } AssignedFTE))


Capture.PNG

posywang
Creator
Creator
Author

Works like a charm! Can you please let me know why we need to round by 0.0000000000001? The source data looks fine to me. Thanks again!

sunny_talwar

The numbers you are summing are 0.3 and 0.35... it seems that although it gets very close to 1, but never actually get 1. So, by rounding to a really small number, we are forcing it to be 1. I think Round(Exp, 0.0001) should work too... but I did this just in case