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: 
niharika1234
Creator
Creator

Adding a New Column to Straight table

Hello,

I want to add a new column showing days late for particular Task. For example the first task 10059 should show days late which is (02/28/20130- 03/08/2018)= 10 days around . But the expression show 1 days. The expression is count(TASK_CLOSED_DATE-TASK_DUE_DATE). Please suggest.

Untitled.png

2 Solutions

Accepted Solutions
Gysbert_Wassenaar

Try sum(Floor(TASK_CLOSED_DATE)-Floor(TASK_DUE_DATE))

talk is cheap, supply exceeds demand

View solution in original post

niharika1234
Creator
Creator
Author

Thanks. It is working now. 

View solution in original post

5 Replies
Gysbert_Wassenaar

Try using the sum function instead of the count function. Count merely counts if task_closed_date - task_due_date returns a result or not.

talk is cheap, supply exceeds demand
niharika1234
Creator
Creator
Author

Thanks. It is working but minor error.

niharika1234
Creator
Creator
Author

Thanks. It is working but minor error. Looks like it is counting hour as well. The Closed date and Due Date are on same date but showing Number days late as  -1. . Also the second one should be 2 days. Please suggest.Untitled.png

Gysbert_Wassenaar

Try sum(Floor(TASK_CLOSED_DATE)-Floor(TASK_DUE_DATE))

talk is cheap, supply exceeds demand
niharika1234
Creator
Creator
Author

Thanks. It is working now.