topic Re: display only value of the last record filtered by Date in QlikView

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

Domross — Fri, 09 Sep 2022 06:28:09 GMT

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

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

maxgro — Fri, 09 Sep 2022 06:28:32 GMT

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)

Re: display only value of the last record filtered by Date

Domross — Thu, 03 Mar 2022 13:42:37 GMT

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 ?

Re: display only value of the last record filtered by Date

maxgro — Fri, 04 Mar 2022 09:38:22 GMT

maybe

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

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm#