Discussion board where members can get started with Qlik Sense.
I am facing Field not found - <Date Received>
when write the code :
QUALIFY "Date Sent",
"From (address)" ;
IF (match(LEFT(Subject,3),'RE:', 'Re:', 're:','rE:'),MID(Subject,4),Subject)
date(date#("Date Received", 'mm/dd/yyyy hh:mm')) as [Date Received],
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
min([Date Received] ) as [First Time Received]
Go to Solution.
You are using a QUALIFY statement, so you need to put "Inbox" before "Date Received" like this:
min([Inbox.Date Received] ) as [First Time Received]