Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Alarkis
Contributor III
Contributor III

Sum or Avg same date field but previous step

 

I want to Sum or Avg same date field but previous step (Action_date)

So i can now how much days it takes between tasks

this is how table looks:

Count -No. -ACTION_DATE -Task

199509820-07-09 12:11New_Application
199509802-08-09 8:59New_Application
199509802-08-09 13:01New_Application
199528713-08-09 10:21New_Application
199528718-08-09 12:58New_Application
199528718-08-09 13:25New_Application
199528718-08-09 13:36New_Application
199528718-08-09 13:38New_Application
199528725-10-09 12:10New_Application
199528725-10-09 12:10New_Application
1100167506-11-13 12:15New_Application
1100167524-12-13 7:13New_Application
1100167524-12-13 7:21New_Application
1100167524-12-13 7:21New_Application
1100167524-12-13 7:21New_Application
2102591321-05-20 16:26New
199528713-06-20 18:05Update
199528714-06-20 0:17UpdateRequest
199528714-06-20 8:42Social
199528714-06-20 14:56Approval
199528715-06-20 1:47Approval
199528702-07-20 12:01Committe
199528702-07-20 12:03Committee
199509809-11-20 9:25Approval
199509809-11-20 12:32Approval
199509825-11-20 11:10Committee
199509825-11-20 12:24Council

expected output:

Count - No. - ACTION_DATE - expected outcome - Task

199509820-07-09 12:110.00New_Application
199509802-08-09 8:590.00New_Application
199509802-08-09 13:010.00New_Application
199528713-08-09 10:2111.00New_Application
199528718-08-09 12:585.00New_Application
199528718-08-09 13:250.00New_Application
199528718-08-09 13:360.00New_Application
199528718-08-09 13:380.00New_Application
199528725-10-09 12:107.00New_Application
199528725-10-09 12:100.00New_Application
1100167506-11-13 12:150.00New_Application
1100167524-12-13 7:1330.00New_Application
1100167524-12-13 7:210.00New_Application
1100167524-12-13 7:210.00New_Application
1100167524-12-13 7:210.00New_Application
2102591321-05-20 16:260.00New
199528713-06-20 18:05 Update
199528714-06-20 0:17 UpdateRequest
199528714-06-20 8:42 Social
199528714-06-20 14:56 Approval
199528715-06-20 1:47 Approval
199528702-07-20 12:01 Committe
199528702-07-20 12:03 Committee
199509809-11-20 9:25 Approval
199509809-11-20 12:32 Approval
199509825-11-20 11:10 Committee
199509825-11-20 12:24 Council
Labels (3)
7 Replies
Anil_Babu_Samineni

What are you expecing as outcome?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Alarkis
Contributor III
Contributor III
Author

Sum of days between tasks based on action_date

Anil_Babu_Samineni

Output please?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Alarkis
Contributor III
Contributor III
Author

I added to main post 

thanks

Anil_Babu_Samineni

Will you able to share more data than 2-5 records? It would be easy to handle if you have different tasks and expected output?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Alarkis
Contributor III
Contributor III
Author

Updated please check

Anil_Babu_Samineni

Sorry, If i am asking too many questions, But I still not understanding your requirement? Why 1st count is Zero since it is counting the value of 2nd step? Can you please explain the logic behind. also confirm where you need script or design?

2020-12-27 14_31_06-Re_ Sum or Avg same date field but previous step - Qlik Community - 1770597.png

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)