Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
brettaustin
New Contributor III

Count Max Date with Another Set Analysis Field

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

  

RecordIDTeamUsageReport Date
1AY1/1/2018
2BN1/1/2018
3CY1/1/2018
4AN2/1/2018
5BY2/1/2018
6CN2/1/2018
7AY3/1/2018
8BY3/1/2018
9CY3/1/2018
10AN4/1/2018
11BN4/1/2018
12CY4/1/2018
1 Solution

Accepted Solutions
Highlighted

Re: Count Max Date with Another Set Analysis Field

May be you are missing a closing parenthesis

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

View solution in original post

3 Replies
Highlighted

Re: Count Max Date with Another Set Analysis Field

May be you are missing a closing parenthesis

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

View solution in original post

Highlighted
brettaustin
New Contributor III

Re: Count Max Date with Another Set Analysis Field

Argh... Thank you!!!!!

Highlighted
sasiparupudi1
Honored Contributor III

Re: Count Max Date with Another Set Analysis Field

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