This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have a crazy requirement
background of this requirement is
i am capturing the employee information on daily basis and each task wise irrespective of shifts
it means example
emp a shift starts at 8 am
emp b shift starts at 1 pm
emp c shift starts at 6 pm
capturing the information irrespective of login time
here for emp a hour 1 is 8 am to 9 am
for emp b is 1pm to 2 pm
for emp c is 6pm to 7 pm
so hour 1 can be anything( any time) ,
now here my requiremnet is i want see the hour1,hour2....,hour9 used tome for all employees
it means emp a will start shift at 8 am ,
08:00 am to 08:30 am meeting
08:30 am to 08:50 am away
08:50 am to 09:00 am is mailbox checking
like wise for all employess we have information
now i want to see all employee usage in hour 1,hour2....hour 9.
tricky thing is here:
if employee exactly ends hour 1 end time then we can easy calculate it but for some of the employees tasks ends like this
08:50 am to 09:10 am is mailbox checking
from abobe data mailbox task is falling under hour 1 and hour 2
so here we have to take 10 mins of time from mailbox and put it into hour 2. and 10 mins time to hour 1 ,
mail box task should be there in both hour 1 and hour 2
I am attaching sample data file to the link pls have a look and let me know ur thoughts
i have source columns like this
Team -team name (database)
SPOC -(emp name)
Start Time -starting time of each employee
End Time - ending time of employee
Time Spent (mins) - time spent
Broad Category - used for (like mails,meetings,away...)
attached my work application .....
Can you read this? Buckets
Can u pls look into this , am not understanding
Can we split as short question rather pages. Because, I am not en-count the issue where we start from. I meant say, please tell us expected result by providing the sample Excel
Please tell us expected result by providing the sample Excel.
Crazy reuirement in qlik life for time calculation?
May be this? I've seen in your excel from sheet2. I assume that is output you need
Yes Exactly Anil
I have attached xl file
pls see the sheet2 for out put
Haha, May be you can close this thread by flag correct answer and Helpful
Note - We are always help you if you still trouble please free to ask till satisfied
no anil ,
hour 1 ,hour 2 columns are calculated in xl level
which i want to do this calculation in qlikview level
only these columns from from xl file ... like
LOAD Team as Empname,
SPOC as empname ,
[Start Time] as Startrime,
[End Time] as Endtime,,
Broad Category as category
(ooxml, embedded labels, table is Sheet1);
from this information we have to calculate hour1,hour 2 ...hour 09 for each employee
time spent for each employee on hourly based....