topic Re: Facing Issue witSet Analysis Exp to get Avg of Variance Time in QlikView

Facing Issue witSet Analysis Exp to get Avg of Variance Time

Sat, 11 Apr 2015 13:10:06 GMT

Hi friends I am stuck with an Issue on Set Analysis please do needful on the Issue

I have data about how effective Resources are utilized in a day/month,

In a day each Resource works for 8 Hours,

I have a dimensions with

PRJ_NM(Project Name)
STAFF_PROF_NM()
RSRC_NM,
month(ALLOC_DATE)as Month_Alloc,
ALLOC_VAL

To calculate avg used below expresson for each/month

sum(aggr(avg((ALLOC_VAL)),PRJ_NM,RSRC_NM,Month_Alloc))/8

As some resources are not utilized 100% need to help on how to calculate the Resource free Time from total

Re: Facing Issue witSet Analysis Exp to get Avg of Variance Time

MK_QSL — Sat, 11 Apr 2015 13:18:15 GMT

For variance, you can use below expression

1-Column(1)

Re: Facing Issue witSet Analysis Exp to get Avg of Variance Time

Sat, 11 Apr 2015 14:50:59 GMT

can you please look into qvw and provide solution as i am not getting your solution

Re: Facing Issue witSet Analysis Exp to get Avg of Variance Time

MK_QSL — Sat, 11 Apr 2015 15:06:28 GMT

File enclosed..

Re: Facing Issue witSet Analysis Exp to get Avg of Variance Time

Sat, 11 Apr 2015 16:22:44 GMT

Sorry from my end as I Assumed Allocation_Value as 1 will be Max(i.e.,1=100%)but for some of the Resources Allocation Value is 1.4,1.2,1.6,2.4,.....

Please look into the Attachment for any further reference.

can you please guide me how to write below

sum(aggr(avg(ALLOC_VAL),PRJ_NM,RSRC_NM,Month_Alloc,MANAGER_NAME))/8 as i Assumed to Allocation Value is 1,but for some of Resources>1

thanks

Re: Facing Issue witSet Analysis Exp to get Avg of Variance Time

Sun, 12 Apr 2015 13:29:26 GMT

hi manish,

when i select on month,avg Allocation is 1 but if i select avg allocation based on years the Allocation value is different, mean sum of all months = year allocation value.

Requirement is when i select on year it should show me the avg allocation value based on years and what was the Variance AND

when i select on the Month it should show me the avg allocation based on months value and what was the Variance.

Regards,

Bhargav