Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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