topic Re: Case count for last 30 days in QlikView

Case count for last 30 days

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to get a count of cases closed over the last 30 days. I've found information off this board and been trying the following formula, but it is not giving me the expected results.

=Count({$<CLOSED_DATE={">=$(=Date(max(CLOSED_DATE)-30))"}>}CASE_ID)

Any help in this issue would be appreciated!

Re: Case count for last 30 days

sunny_talwar — Thu, 29 Sep 2016 16:34:06 GMT

Are you seeing anything or are you getting 0? May be try adding the date format for your closed date:

=Count({$<CLOSED_DATE={">=$(=Date(Max(CLOSED_DATE)-30, 'DateFormatHere'))"}>} CASE_ID)

Re: Case count for last 30 days

Gysbert_Wassenaar — Thu, 29 Sep 2016 16:35:15 GMT

Perhaps you need to add a date format to the date function. That would be needed if the date values in CLOSED_DATE have a different format then the document default.

=Count({$<CLOSED_DATE={">=$(=Date(max(CLOSED_DATE)-30,'MM/DD/YYYY'))"}>}CASE_ID)

Re: Case count for last 30 days

Thu, 29 Sep 2016 16:42:58 GMT

Problem solved...thank you for the rapid response!!

Re: Case count for last 30 days

Thu, 29 Sep 2016 16:46:10 GMT

=Count({<CLOSED_DATE={">=Date(max(CLOSED_DATE)-30)<=Date(max(CLOSED_DATE))"}>}CASE_ID)

try this

Re: Case count for last 30 days

Thu, 29 Sep 2016 16:58:48 GMT

Sorry, this did not work, but thank you for the suggestion