Date If Issue (Model and Application help)

wgoudeau — Fri, 04 Feb 2022 18:08:09 GMT

Hello, I am having issues with my Date inside the data model and the application.

Below is an excerpt of the data model:

TABLE1:

LET vMinDate = Floor(AddMonths(Today(),-24));
LET vMaxDate = floor(Today());

.....

TABLE1:

.....

if(
Date(if(Source = 'PR Entry ',ActualDate,PostedDate))<Date(Mth)
or
Date(if(Source = 'PR Entry ',ActualDate,PostedDate))>Date(Mth),Date(Mth),
Month(if(Source = 'PR Entry ',ActualDate,PostedDate))) as Date,

.....

Is there something wrong with my above IF Statement?

.....

***The Wages, Load, etc are not populating either?

Sort order:

topic Date If Issue (Model and Application help) in QlikView

Date If Issue (Model and Application help)