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: 
hammermill21
Creator III
Creator III

Counting the differences between two dates greater than 24

Hello,

I have two dates/;

Call Date & Work Date, I want to count the days between those two days that are greater than 24. I tried this:

(Count([Call Date] - [Work Date])) > 24 but that is not working

Thank you

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(If([Call Date] - [Work Date] > 24, 1, 0))

View solution in original post

9 Replies
sunny_talwar

May be this

Sum(If([Call Date] - [Work Date] > 24, 1, 0))

kuczynska
Creator III
Creator III

Date1-Date2  will give you the difference in days, so you simply have to wrap it in the statement Sunny wrote above.

clondono
Creator III
Creator III

Hi Elizabeth,

How about using set analysis. Maybe something like:

count(<{NetWorkDays([Call Date], [Work Date]={"> 24"}>},NetWorkDays([Call Date], [Work Date])) 


Thanks,

Carlos

consultant_bi
Creator
Creator

Hello Carlos

i thought about the same thing

clondono
Creator III
Creator III

Thanks Fathi,

I just noticed that I am missing a parenthesis in my expression.

Here is the revised code:

count(<{NetWorkDays([Call Date], [Work Date])={"> 24"}>},NetWorkDays([Call Date], [Work Date]))

sunny_talwar

This won't work as you cannot use functions/calculations on the left hand side of a set modifier... you can perform the same calculation in the script to create a field as an alternative

zebhashmi
Specialist
Specialist

I think

Count(If([Work Date] - [Call Date] > 1, 1))

asuming 24 hrs


hammermill21
Creator III
Creator III
Author

Thank you

hammermill21
Creator III
Creator III
Author

Thank you for your help!