Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to get rest of available employee in company?

DateEmployee
1/1/201850
1/2/201810
1/2/2018-15
1/3/201840
1/3/2018-5


In that table contain employee join and resign in specific date. we need how many employee available in last in script level.

6 Replies
Contributor III
Contributor III

Result should be 80 number of employee

Specialist III
Specialist III

How about Sum(Employee)?

Contributor III
Contributor III

Is it possible write in script level sum()

i try  this one

load

Date,

Employee+peek(Employee) as EmployeeNo

from Emplyoee;

Specialist III
Specialist III

tab1:
LOAD Sum(Employee) As SUM_Emp
;
LOAD * INLINE [
    Date, Employee
    1/1/2018, 50
    1/2/2018, 10
    1/2/2018, -15
    1/3/2018, 40
    1/3/2018, -5
];
Specialist III
Specialist III

One solution is.

tab1:
LOAD *, RangeSum(Peek(Sum_Emp),Employee) As Sum_Emp
;
LOAD RecNo() As RowID, * INLINE [
    Date, Employee
    1/1/2018, 50
    1/2/2018, 10
    1/2/2018, -15
    1/3/2018, 40
    1/3/2018, -5
];
Specialist III
Specialist III

commQV89.PNG