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
@tresesco
