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 an employee database in which we are capturing previous organisation details also.
So, while taking the same, i want to order the organisations that an employee has already work upon.
1. Last Company
2.Second last company
3. Third last company
I am using the below code to give it the order:
LOAD description as Prev_org_desc,
1 as order,
enddate as Prev_org_end_date,
organisation_name as Prev_org_name,
rid as Prev_org_role_id,
role as Prev_org_role,
startdate as Prev_org_Start_date
Prev_org_end_date as EndDate,
Prev_org_Start_date as StartDate,
Prev_org_name as PreviousOrgName,
Prev_org_role as PrevORGRole,
(num(Prev_org_end_date)-num(Prev_org_Start_date))/365 as tenure,
if(eid=peek(eid),peek(order)+1,order) as PrevOrgOrder ;
But the output only gives PrevOrgOrder =1 for the last company employee worked for. For other porevious organisations, this field is null.
Can you please help me finding the bug in the code and let me know if any mistake i am making in the concept.
Thanks in advance.
Check my response here
Order of projects in employee details