topic Re: Count Max Date with Another Set Analysis Field in QlikView

Count Max Date with Another Set Analysis Field

brettaustin — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to count the total teams with a 'Y' usage for the current reporting period.

WHERE the Usage Flag is 'Y'

AND

The Report Date is the maximum for the current 'reporting period'. See below for data example

= count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date]))"}>} RecordID)

Total Should equal 1 because the max date is 4/1/2018

sunny_talwar — Wed, 25 Apr 2018 17:17:29 GMT

May be you are missing a closing parenthesis

=Count( {$< [Usage] = {"Y"}, [Report Date] = {"$(=Date(max([Report Date])))"}>} RecordID)

brettaustin — Wed, 25 Apr 2018 19:45:15 GMT

Argh... Thank you!!!!!

sasiparupudi1 — Fri, 27 Apr 2018 12:48:26 GMT

if you got your answer, please close this thread by marking a correct and any helpful answers