Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Table chart with only Max Data rows

I have to make a table graph, which shows me the ID_FORNITURA and ID_DOCUMENTO fields, inside there is a DATE field which also contains the historical data with old data, I need to have a table which contains only the latest ones, i.e. the current ones with the last date, how to do?

I did that, but it doesn't work:

on dimension i put: id_documenti, id_fornitura

on expression i put: =Max(T_FATTURE_SINTESI_ST.DATAFOTO)

but in this way i see the data OLD too, i want to show only the record have, in this example, the date 16/07/2023

danosoft_0-1689605914503.png

 

 

 

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Like this.

=Only({$<datafoto= {"$(=Max(datafoto))"}>}datafoto)

View solution in original post

2 Replies
BrunPierre
Partner - Master II
Partner - Master II

Like this.

=Only({$<datafoto= {"$(=Max(datafoto))"}>}datafoto)

danosoft
Specialist
Specialist
Author

This work, thanks, but can you explain to me what did you do?

Thanks