Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Not sure if this is possible, but with the data I am working with I am stuck.
I have these fields:
Billable Hours
Network Days Flag
Employee
I am trying to perform a calculation if the...
(sum of billable hours) - (sum of Network Days Flag * 😎 >= 20, then sum the list of employees.
My current expression(that doesn't work):
Sum(if(Sum([Billable Hours])-Sum([Network Days Flag])*8>=20)[Employee])
Thanks in advance
I feel like this should work, but I can only use it as a measure. Is there any way something like this could work as a dimension? If I use Employee as a dimension, then use this as the measure, it does not output correctly when charting. Thank you for your help, just can't get the results I need.
So, if I have a pivot table or bar chart for example. how can I apply this? Is their a way to make this a filter or dimension? Right now, this only work as a measure. So all of my employees are being charted. I would only like to see the specific employees that are over the condition. Thanks
send us your sample .QVF file we can be able help you
AGGR(
if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8)>=20,[Employee])
,[Employee])
For Calculated Dimension
It is to work. he's checking account for the size , if the sum more than 20 for the employee he says. example help QlikView
sum( {$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales )
Thank you all so much. This is the one that finally gave me my results. I have tested the data and finally return true!
Thank you Rodrigo, I perhaps wasn't specific enough. I tired my best to explain. Anyways cheers!
Vineeth,
The below code is working great. Thanks again. I was just wondering, for a calculated dimension is it possible to use a "OR" in the condition?
So can we take:
AGGR(if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8) < 0,[Employee]),[Employee])
and somehow make a calculation of
AGGR(if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8) < 0 "||" employee <= -20,[Employee]),[Employee])
I have been finally understanding the use of aggr, but can't find any documentation on this.
Thanks in advance
Change as below
AGGR(if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8) < 0 OR employee <= -20,[Employee]),[Employee])
Is employee a numeric field? You are compating it with -20
What I was trying to at was if the:
AGGR(if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8) < 0
OR
AGGR(if( Sum([Billable Hours]) - (Sum([Network Days Flag])*8) <= -20
would this work in any way?