Display only the value of last record filtered by Date in the record

[Domross]

Hi all , how to display in test only the last value of record filtered by DateTo ?

[maxgro · Accepted solution]

If I understand the question, you can make a chart with one dimension (Distributore) and 2 measures filtered by DataRiferimento (DataRiferimento is the variable in Calendar object)

FirstSortedValue({$ <Data={"<=$(=DATE(DataRiferimento))"}>} Data, -Data)

FirstSortedValue({$ <Data={"<=$(=DATE(DataRiferimento))"}>} Importo, -Data)

[Domross · Accepted solution]

thnks maxgro ,

your solution solved my first problem , now i have another question , the total in a pivot ( or not pivot ) graph is not correct. (see 14 not 42  )  what is the solution ?

[maxgro · Accepted solution]

maybe

SUM(AGGR(FirstSortedValue({$ <Data={"<=$(=DATE(DataRiferimento))"}>} Importo, -Data), Distributore))

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Ne...