topic Re: Get value for max(date) which is not null in QlikView

Get value for max(date) which is not null

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

Hi,

I need to show the value for the maximal date that is available. Now my problem is I get some values later than other thus max(date) in set analysis is not an option. Further I have some forecast values which means I have values until the end of the year.

How can I now display the most recent value which is not null??

Thank you in advance.

Oliver

Re: Get value for max(date) which is not null

sunny_talwar — Fri, 22 Jul 2016 14:21:39 GMT

May be like this:

FirstSortedValue({<value = {'*'}>} value, -date)

or provide a sample if this does not work

Re: Get value for max(date) which is not null

obruski10 — Tue, 26 Jul 2016 11:17:43 GMT

Thank you! Works perfectly.