Solved: Id wise display the rolling sum - Qlik Community

Ramu_i · ‎2022-05-13

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

vikasmahajan · ‎2022-05-17

PFA attached QVF you can Network function

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

View solution in original post

vikasmahajan · ‎2022-05-17

PFA attached QVF you can Network function

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

Id wise display the rolling sum

Chart

Data Load Editor

Developers

dimension

expression

filter

Script

Set Analysis

Variables

Visualization