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: 
joeboulware2000
Contributor
Contributor

How to add a count for difference in days

I have a table that has a Open Date and Close Date columns.

I added a Measure column to determine the number of days it took for a record to be Closed.  For example, Open Date is 1/1/2022 and Close Date is 1/2/2022, it would be one (1) day.

I would like to add a table that would do a count based on the number of days a record is open.  For example # of records opened for < 30 days, 31 days - 60 days, > 60, etc.

Any help on this would be great, thanks!

Labels (1)
1 Solution

Accepted Solutions
Channa
Specialist III
Specialist III

to get number of days use

OpendDate-Close date as Days

to get records that less than 30

use resident load where Days <30

 

you can make it in report also

use set analysis or if statement

if( days<30, closedate)

Channa

View solution in original post

1 Reply
Channa
Specialist III
Specialist III

to get number of days use

OpendDate-Close date as Days

to get records that less than 30

use resident load where Days <30

 

you can make it in report also

use set analysis or if statement

if( days<30, closedate)

Channa