Table chart with only Max Data rows

danosoft — Mon, 17 Jul 2023 14:59:01 GMT

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

Re: Table chart with only Max Data rows

BrunPierre — Tue, 18 Jul 2023 09:49:16 GMT

Like this.

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

Re: Table chart with only Max Data rows

danosoft — Tue, 18 Jul 2023 09:53:30 GMT

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

Thanks

topic Re: Table chart with only Max Data rows in QlikView

Table chart with only Max Data rows

Re: Table chart with only Max Data rows

Re: Table chart with only Max Data rows