Max Date

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to set the =date(max(Date) equal to or less than the =date(Today()). The date needs to stay dynamic but not exceed todays date because it messes up my calculations. Tried multiple IF statements and been unsuccessful. The reason for that is it uses the [Bill Date] and not the selected date. and returns a False statement. Below is the expression I'm currently trying. This software is still new to me. Any and all help will be most welcomed.

sum(
{$<
   [Bill Date] = {"<=$(=date(max([Date])))>$(=date(max([Date])-90))"},
    [Year]=,
   [Period]=,
   [Date] = {"<=$(=date(Today()))>=$(=date(min(Date)))"},
    [Month]=,
   [Calendar Year] =,
LinkId = {"FIN"}
>}
[Bill Quantity])
/
90

Re: Max Date

marcus_sommer — Sat, 10 Dec 2016 13:06:11 GMT

I think you will need to give more background to your question - maybe within a small example. I wouldn't be surprised if you would need a canonical date to connect both of your date-fields, see: Canonical Date.

- Marcus

topic Max Date in QlikView

Max Date

Re: Max Date