Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramu_i
Contributor III
Contributor III

Id wise display the rolling sum

Hi All,

Employee data is available,

Here Data is

R_EMP ID R_Emp Name R_Sal Month Year Leaves Joining Date
1 Ram 10000 Jan 2022 1 01-05-2022
2 Raj 20000 Jan 2022 0 02-05-2021
3 Soni 15000 Jan 2022 0 03-05-2020
1 Ram 10000 Feb 2022 0 01-05-2022
2 Raj 20000 Feb 2022 2 02-05-2021
3 Soni 15000 Feb 2022 3 03-05-2020
1 Ram 10000 Mar 2022 0 01-05-2022
2 Raj 20000 Mar 2022 0 02-05-2021
3 Soni 15000 Mar 2022 0 03-05-2020

 

O/P:

R_EMP ID R_Emp Name R_Sal Leaves Number of working Days
1 Ram 30000 1 2022-300 days,2021-315 days
2 Raj 60000 2  
3 Soni 45000 3  

 

Number of working days display the total number of working days in the particular year. Only working days(Mon-Fri).

Thank in advance.

Ram

 

1 Solution

Accepted Solutions
vikasmahajan

PFA attached QVF you can Network function 

vikasmahajan_0-1652769326900.png

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

1 Reply
vikasmahajan

PFA attached QVF you can Network function 

vikasmahajan_0-1652769326900.png

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.