distinct count when for max record between date range dynamically

sai_yashwan — Tue, 22 Sep 2020 02:25:58 GMT

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

Re: distinct count when for max record between date range dynamically

Brett_Bleess — Thu, 15 Oct 2020 20:41:25 GMT

See the following related post:

https://community.qlik.com/t5/QlikView-App-Development/count-of-MAX-record-for-dynamically-changing-the-date-variables/m-p/1746210#M453325

Regards,
Brett

topic distinct count when for max record between date range dynamically in QlikView

distinct count when for max record between date range dynamically

Re: distinct count when for max record between date range dynamically