Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Partner - Master

Like this.

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

View solution in original post

2 Replies
BrunPierre
Partner - Master
Partner - Master

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