Thanks for the replys, but I dont think I'm able to apply them in this situation.
qlikdisqruser1, that would work if the goals were already calculated and in a table, prob is as of right now, I used QV to calculate the goals. Thanks, though.
Sebastian, I'm unfamiliar with the Total function, it might work, but I'm not sure how to apply it. Can you break down what it does?
I think my problem is that the goal is not in a table, it is a calulation of a few variables defined in the script. When you put in the person dimension, QV automatically assumes you want the calc split out by the individuals, while with this situation, I dont want it to do that.
Not that it matters, but here is the Goal calc:
((($(1stGoal)*$(eSum_e_1stOtherGoal)))/$(PersonCount))+(($(2ndGoal))*($(eSum_e_2ndGoal)))/$(PersonCount)+(($(3rdGoal))*($(eSum_e_3rdGoal)))/$(PersonCount)
Basically, A+B+C/Count of users.
That calc comes out fine for weekly values because the records are not assigned to a user and are easily aggregated.
Think call center where many users are calling many leads and there is overlap.
When I add the person dimension in, due to the realational data model, QV looks for the User in the datamodel and assigns only records that user is associated with, and returns a significantly lower value for the same/simular calc, as the user has only dealt with a small sample of records.
Is there a way through set analysis to disregard the dimension, or reference a result from another chart?
My next option is to write some sql to do the goal/user/week calc and bring it in as a field in the data model and be done with this madness.
Thanks again, please let me know if there are any other ideas/options.
