Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
wgoudeau
Contributor II
Contributor II

Date If Issue (Model and Application help)

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?

.....

wgoudeau_0-1643997448697.png

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

 

Sort order:

wgoudeau_1-1643997646008.png

 

 

0 Replies