topic Why Max Date is never equal to Date? in QlikView

Why Max Date is never equal to Date?

carahyba — Wed, 17 Aug 2016 22:24:16 GMT

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.

Re: Why Max Date is never equal to Date?

sunny_talwar — Thu, 18 Aug 2016 00:56:07 GMT

Try this:

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

Re: Why Max Date is never equal to Date?

oknotsen — Thu, 18 Aug 2016 00:58:53 GMT

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')

Re: Why Max Date is never equal to Date?

carahyba — Fri, 19 Aug 2016 14:48:32 GMT

Thank you so much!

Re: Why Max Date is never equal to Date?

carahyba — Fri, 19 Aug 2016 14:48:50 GMT

Thank you so much!

Re: Why Max Date is never equal to Date?

carahyba — Fri, 19 Aug 2016 14:54:40 GMT

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!