Problem in multi selection of years

[#1]

I want display worked hours per EMP_ID  month wise , year wise and multi selection of months and years alone.
employee worked hours enter daily basis
here condition is worked hours <4 is available,>=4&<8 is partially available,>=8 is occupied.
could you please tell me script level

Regards

Niranjan

[zhadrakas]

Hello Niranjan,

try this

Source_Data:
LOAD * INLINE [
EMP_ID, WorkedHours, SheetDate
101, 2, '1/11/2015'
102, 3, '2/12/2015'
103, 4, '3/13/2015'
104, 5, '4/13/2015'
105, 6, '5/14/2015'
106, 7, '6/15/2015'
107, 8, '7/16/2015'
];

Load EMP_ID,
WorkedHours,
if(WorkedHours>=8, 'occupied',
if(WorkedHours>=4, 'partially available',
if(WorkedHours>0, 'is available'))) as EMP_STATE,
Date(SheetDate) as SheetDate,
year(SheetDate) as Year,
month(SheetDate) as Month
Resident Source_Data;

drop table Source_Data;

regards

Tim

[#3]

Tim Driller,

when i select particular month(Feb) need to consider all Feb month for all years and finally showing that month employee status(available or partially available or occupied)

[zhadrakas]

Hello niranjan,

i dont understand what you want to achieve.

do you want to sum the workedhours for alle "Feb" Values?

Like this?

EMP_ID	WorkedHours	Month	EMP_STATE
101	6	Feb	partially available

[praveenkumar_s]

Tim Driller,

worked hours are 6 and divided by 2 because of two days worked finally worked hours 3 i.e EMP_State is Available

based on condition 

[vishsaggi]

Hello Niranjan,

There is a similar topic here with the same request and similar text and Image but a different person named Yuvaraj G. I was confused , were you both work together or is this the same person? Just wondering?.

Problem in multi selections in years

[zhadrakas]

check if this is what you want...

regards

tim

[#8]

he is my colleague

[#9]

that qvw is not opening because i am using personal edition

[vishsaggi]

Ok, got it. Just thought would ask. Did you find the solution yet? Can you give us more information on your expected output or a sample app you are working on would help?