distinct count when for max record between date range dynamically

[sai_yashwan]

I have a requirement to pull the max record(key)  per case between the date ranges dynamically selected .. 

below requirement pulls everything bys elected date range .. but my requirement is to select the recent record only when user run report per date range ..for ex - if user runs the report 09/14/2017 to 09/15/2018 i need recent record fro that time frame per case.. could you please help on this urget requirement? 

=Count(distinct if( [Type ]='BV' and Status='Complete'  and DateType ='CaseCreatedDate' and (Date>=DayName(vStDt) and Date<=DayName(vEdDt) ) , Key))

case	key	status	date	rnk
123	12324	complete	09/12/2019	1
123	12325	complete	09/13/2018	2
123	12326	complete	09/14/2017	3
126	12327	complete	09/15/2017	4
126	12328	complete	09/16/2018	3
126	12329	complete	09/17/2020	1
129	12330	complete	09/18/2019	2
129	12331	complete	09/19/2015	4
129	12330	complete	09/20/2014	5
129	12331	complete	09/21/2015	3
131	12332	complete	09/22/2020	1
132	12333	complete	09/23/2015	2

[Brett_Bleess]

See the following related post:

https://community.qlik.com/t5/QlikView-App-Development/count-of-MAX-record-for-dynamically-changing-...

Regards,
Brett