Why Max Date is never equal to Date?

[carahyba]

Hi, there.

I'm trying something like described in this post: How exclude Rows from table? | Qlik Community. But, for some unknown reason (at last for me), the IF statement is never true. An example is attached, if someone can help, I appreciate.

Thanks.

C.

[sunny_talwar · Accepted solution]

Try this:

=Aggr(If(Max(TOTAL <Doc>[Date]) = Date,'Yes','No'), Doc, Code, Date)

[oknotsen]

No clue why your If statement does not work (except that apparently it is wrong), but here is an alternative solution:

Assuming the table you load first is called "Source", add this to your script:

DateTmp:

Left Join(Source)

Load

  Doc,

  date(max(Date)) as MaxDate

Resident Source

group by Doc

;

After that, you can add this expression to your chart:

If(Date = MaxDate, 'Yes', 'No')

[carahyba]

Thank you so much!

[carahyba]

Thank you so much!

[carahyba]

Both are correct answer! Unfortunately I can choose only one, so I checked the first one. But in the attach I implemented both.

Thanks again, @Sunny and @Onno.

Best regards!