topic Re: Bring the allocation level in day wise in QlikView

Bring the allocation level in day wise

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In below image I have a allocation level in date wise so, I need to use Pie chart for allocation level to find count of how many employees are occupied ,Partially occupied and Available , Allocation level as IF( worked_hours>7, 'Occupied', IF( worked_hours>3 and worked_hours<8, 'Partially Occupied', IF( worked_hours<4, 'Available' ))) so What can I give as dimensional and expression in Pie chart to show day wise allocation

Re: Bring the allocation level in day wise

Anil_Babu_Samineni — Thu, 30 Mar 2017 17:36:22 GMT

Instead of Pie chart, I would go Funnel chart for this

Dimension as

IF(worked_hours<4, 'Occupied', IF(worked_hours>3 and worked_hours<8, 'Partially Occupied', IF( worked_hours>7, 'Available' )))

Expression what you want to calculate

may be ---- Sum(Measure) or Count(Measure) {Measure may be -- ProcessTaskID / ResourceId}

or you can try same with Pie chart if you required to show.

Re: Bring the allocation level in day wise

Anonymous — Fri, 31 Mar 2017 07:23:07 GMT

ok thanks I will try it

Re: Bring the allocation level in day wise

yoganantha321 — Thu, 06 Apr 2017 13:05:08 GMT

Hi vijay,

kindly follow the below expression:

=count(Aggr(if(round(sum(worked_hours)/Count(sheet_date))>7,EmployeeID),EmployeeID)) // Occupied

Repeat it for remaining two....

I think it will be useful