topic Re: Last figure in QlikView

Last figure

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

Test:
LOAD * INLINE
[myDate, Utilisation, Capacity (23.3TB)
25/07/2016, 92.62, 22.105
01/08/2016, 91.69, 21.883
08/08/2016, 91.08, 21.738
15/08/2016, 91.38, 21.809
22/08/2016, 91.85, 21.921
29/08/2016, 91.85, 21.921
07/09/2016
08/09/2016
10/09/2016
];

Imagine myDate is infinite. I would like to get the last Utilisation figure 91.85 without explicitly saying myDate= 29/08/2016

I am trying to get the logic behind it.

//sum({< myDate >}Utilisation

Re: Last figure

effinty2112 — Thu, 01 Sep 2016 09:35:56 GMT

Hi David,

try:

=FirstSortedValue({$<Utilisation ={">0"}>}Utilisation,-myDate)

Kind regards

Andrew

Re: Last figure

Chanty4u — Thu, 01 Sep 2016 09:36:41 GMT

try this in front end

=FirstSortedValue(Utilisation,-myDate)

Re: Last figure

Anonymous — Thu, 01 Sep 2016 09:36:52 GMT

Try This,

=sum({<myDate = {"=Max(Date)"}>}Utilisation)

Re: Last figure

Kushal_Chawda — Thu, 01 Sep 2016 09:40:14 GMT

try this

=sum({<Date={"$(=date(max({<Utilization={">0"}>}Date)))"}>}Utilization)