topic How is that possible? in QlikView

How is that possible?

NenadV — Thu, 02 Apr 2026 14:00:33 GMT

Hi,

This can’t be simpler, but it doesn’t work as expected and as it has been working for 11 years.

if(date(PL03006) > date(today()), 'N', 'Y') as P_OpenInv_Overdue,

For example, an Invoice with a due date of 2026-04-01 4 is shown as overdue, which, based on the above if statement it should not be the case.

FYI:

DueDate in ERP: PL03006 with this value in the DB: 2026-04-29 00:00:00.000

Re: How is that possible?

marcus_sommer — Thu, 02 Apr 2026 14:17:28 GMT

I would look on the real loaded values in QV. Means something like:

PL03006 as A
isnum(PL03006) as B
today() as C,
recno() as RecNo,
rowno() as RowNo,
...

and then using a table-box to look on these values.

Re: How is that possible?

NenadV — Thu, 02 Apr 2026 14:52:56 GMT

DueDate in QlikView is normal Date type of field so there should be no issues, whatsoever.

Re: How is that possible?

NenadV — Thu, 02 Apr 2026 14:54:38 GMT

DueDate in QlikView is normal Date type of field so there should be no issues, whatsoever.

Re: How is that possible?

marcus_sommer — Thu, 02 Apr 2026 15:10:47 GMT

Are you looking on the same respectively the right field? Further the tags are only an indicator and no certainty that really all values have the proper pattern and the expected values. The incoming values might be wrong, empty or missing/null ...

Also there might be n different values in regard to the dimensionality and depending on how to look on them you may not see the entire truths. Therefore the above suggestion to look at first on the real existing values within a table-box.

Re: How is that possible?

NenadV — Fri, 03 Apr 2026 07:26:02 GMT

@marcus_sommer , here are the values:

Re: How is that possible?

NenadV — Fri, 03 Apr 2026 13:34:26 GMT

This if(date(PL03006) < date(today()), 'Y', 'N') as P_OpenInv_Overdue,

has started working ok as it hs been workinig nice in the last 11 years . Case closed. Thanks @marcus_sommer for your time and good will.

happy Easter.