topic Re: Display Max(Date) where associated field is not null in QlikView

Display Max(Date) where associated field is not null

Fri, 03 Jul 2015 14:48:44 GMT

Hello lovely people

I would like to select the last record date where the ID isn't NULL.

I can do it in a chart, but I need to do it in a text box and can't for the life of me work it out.

Help!

Gabriel — Fri, 03 Jul 2015 16:17:00 GMT

Hi,

Try this

=Date(Max(Aggr(Date(Date),ID,Date)))

antoniotiman — Fri, 03 Jul 2015 18:46:11 GMT

Hi Lewis,

=Date(Max({<ID={*}>} Date))

=Date(Max(If(Not IsNull(ID),Date)))

Regards,

Antonio

MarcoWedel — Sat, 04 Jul 2015 10:21:52 GMT

=FirstSortedValue({$<ID={"*"}>} distinct Date,-Date)

hope this helps

regards

Marco

Mon, 06 Jul 2015 08:14:26 GMT

Thanks for your help chaps.

Mon, 06 Jul 2015 08:16:13 GMT

Thanks for your reply Gabriel. However, this gives me the last date in the table, regardless of whether the ID is null or not.

Do you have any other example that could satisfy this problem, but still use AGGR? I'm keen to get to grips with that function.