strucked with set analysis

Fri, 17 Apr 2015 13:21:03 GMT

Hi all,

strucked with set analysis,

table is like

Resource month exression(allocation _ project (allocation in hours) ! ! ! ! !

kishore jan 1 project1

raj jan 0.1 project2

srikanth jan 0.8 project1

kishore feb 1 project1

raj feb 0.1 project2

srikanth feb 0.8 project1

kishore mar 1 project1

raj mar 0.1 project2

srikanth mar 0.8 project1

swetha mar 1.2 project3

to get these allocation i have used these expression:sum(allocation)/(176*(Count(DISTINCT month))

I want to see the count of resources where allocation <=0.8,

here i have tried count of resources where allocation<=0.8 on months

when i am trying to do these expression on years, not getting properly.

=sum((aggr(if(sum(allocation)/(176*(Count(DISTINCT month)))<0.8,count(distinct(Resource))),Resource,month))) //(In Text Object)

for example,

Resource month allocation project

srikanth jan 0.8 project1

srikanth feb 0.8 project1

srikanth mar 0.8 project1

when i 1) select month jan allocation(0.8)<=0.8 count=1

2) select month feb allocation(0.8)<=0.8 count=1

3) select month mar allocation(0.8)<=0.8 count=1

Problem:when i am selecting all 3 months resource count is (1+1+1)=3 but,(based on above mentioned expression)

my requirement is when i select all 3 months i want to get the (0.8+0.6+0.7)/month=(0.7)(count will be ONE)

allocation(0.7)<=0.8(resource count should be one

Can you please help on these , find the attachment

Regards,

Sruthi

topic strucked with set analysis in QlikView