Adding an aggr and separate value

Anonymous — Wed, 19 Nov 2014 18:03:56 GMT

Hello everyone,

I have an issue where I'm trying to add hours from several teams together, plus hours from one member of a different team. I'm having trouble getting the correct string to make this happen. This is my current string:

aggr(Sum({$<TeamOT={'Team A','Team B','Team C','Team D'}>} OTTotal), OTMoyr)

Team E has a member, Anna, that I need to include in the total hours above, but I can't figure out how to do that. I don't need the rest of Team E, just Anna. I have an EmpID field with all employee ID's, and I was trying to figure a way to use that in the string, but nothing I tried worked.

Any ideas would be greatly appreciated!

Re: Adding an aggr and separate value

Gysbert_Wassenaar — Wed, 19 Nov 2014 19:18:59 GMT

Something like:

Sum({$<TeamOT={'Team A','Team B','Team C','Team D'}>+<TeamOT={'E'},EmpID={'Anna0123'}>} OTTotal)

Re: Adding an aggr and separate value

Anonymous — Thu, 20 Nov 2014 12:31:35 GMT

Worked perfectly! Thanks,Gysbert!

topic Adding an aggr and separate value in QlikView

Adding an aggr and separate value

Re: Adding an aggr and separate value

Re: Adding an aggr and separate value