Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
johnnyjohn
Contributor
Contributor

Filter dimensions to only max date

Capture.PNG

 

I have the data show in the image. All my columns are dimensions apart from the very first one.

I need to filter the table so that each client (second column), only the information for the latest date is shows (the one underlined in red.)

How can I do this? 

2 Replies
GaryGiles
Specialist
Specialist


=Timestamp(aggr(max(Last_Execution_Date), Counterparty_Description),'DD/MM/YYYY hh:mm:ss')

johnnyjohn
Contributor
Contributor
Author

Capture.PNG

Thanks for the reply. However, when I try to add another column (here Quantity Available), I get multiple rows. I just need to get the quantity that was at the last time, i.e. 13204  was done as the Quantity Available for Actiam in the MAX time period, seen in the original question. How can I do this? Thanks