New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Contributor 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 MVP

Re: Counting the differences between two dates greater than 24

May be this

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

9 Replies MVP

Re: Counting the differences between two dates greater than 24

May be this

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

Contributor III

Re: Counting the differences between two dates greater than 24

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

Contributor III

Re: Counting the differences between two dates greater than 24

Hi Elizabeth,

How about using set analysis. Maybe something like:

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

Thanks,

Carlos

Contributor

Re: Counting the differences between two dates greater than 24

Hello Carlos

i thought about the same thing

Contributor III

Re: Counting the differences between two dates greater than 24

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])) MVP

Re: Counting the differences between two dates greater than 24

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 Valued Contributor

Re: Counting the differences between two dates greater than 24

I think

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

asuming 24 hrs

Contributor III

Thank you

Contributor III

Re: Counting the differences between two dates greater than 24

Thank you for your help!