Show data for last Friday date in a table

Aspiring_Developer — Thu, 05 Sep 2024 14:40:36 GMT

Hello All ,

I have below data set in qlik :-

REGISTRATION	ASSET_TYPE	UTC_CATEGORY	FUEL_TYPE	Date
FG21TZM	VAN	MEDIUM VAN	Electric	7/26/2024 0:00
FG21UBW	VAN	MEDIUM VAN	Electric	7/5/2024 0:00
FG22SJX	VAN	MEDIUM VAN	Electric	7/12/2024 0:00
FG71HXZ	VAN	MEDIUM VAN	Electric	7/26/2024 0:00
FG71KTL	VAN	MEDIUM VAN	Electric	7/26/2024 0:00
FG71MFV	VAN	MEDIUM VAN	Electric	7/19/2024 0:00
FH21DZW	VAN	MEDIUM VAN	Electric	7/26/2024 0:00
FH21ZTP	VAN	MEDIUM VAN	Electric	7/5/2024 0:00

I want to create a table in front end with below details :-

Dimensions	Date	Only show the max date of each month	7/26/2024 0:00
Measure	Count(Registrations)	`4	all records corresponding to maximum date of the month available in the data set

In the above table the Date dimension show show most recent date of the month . We have dates for each friday in the month and it show only show the most recnet friday date as dimensions and in measure it should show the count of registrations with respect to the most recent date of the month , for ex- 4 as we have 4 entries in my data set against date 26th . How can I achieve this ?

Thanks

@tresB

Re: Show data for last Friday date in a table

Kushal_Chawda — Fri, 06 Sep 2024 12:30:11 GMT

@Aspiring_Developer try below

= FirstSortedValue ( distinct aggr(count(Registrations),Date), - Date)

topic Show data for last Friday date in a table in App Development

Show data for last Friday date in a table

Re: Show data for last Friday date in a table