Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dpstanley_13
Contributor III
Contributor III

Left Join - field not found

I have hit a wall and need another set of eyes on this.  I don't know why I am getting the "Field not found" error.

DateRangeBridge:
LOAD Distinct
Num(Date#(MeasureMonthDTS, 'YYYY-MM-DD')) & Num(Date#(MeasureMonthEndDTS, 'YYYY-MM-DD')) AS BridgeKey
,MeasureMonthDTS
,MeasureMonthEndDTS

Resident Fact;

Left Join (DateRangeBridge)

LOAD DateDT
Resident Calendar
Where Date(DateDT) >= Date(MeasureMonthDTS) and Date(DateDT) <= Date(MeasureMonthEndDTS);

Field 'MeasureMonthDTS' not found

Labels (1)
0 Replies