Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Help me with script error

Hi

I am facing Field not found - <Date Received>

when write the code :

QUALIFY     "Date Sent",

    "To (address)",

    [Date Received],

    "From (address)" ;

[Inbox]:

LOAD

IF (match(LEFT(Subject,3),'RE:', 'Re:', 're:','rE:'),MID(Subject,4),Subject)

as Subject,

    "Date Sent",

    "To (address)",

    [Date Received],

    "From (address)"

;

LOAD

    Subject,

    "Date Sent",

    "To (address)",

    date(date#("Date Received", 'mm/dd/yyyy hh:mm')) as [Date Received],

    "From (address)"

FROM [lib://Data/Deloitte_inbox.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

UNQUALIFY;

[MIN_INBOX]:

LOAD

    Subject,

    min([Date Received] ) as [First Time Received]

RESIDENT [Inbox]

GROUP BY

    Subject ;

1 Solution

Accepted Solutions
Employee
Employee

Re: Help me with script error

Hi,

You are using a QUALIFY statement, so you need to put "Inbox" before "Date Received" like this:

[MIN_INBOX]:

LOAD

    Subject,

    min([Inbox.Date Received] ) as [First Time Received]

RESIDENT [Inbox]

GROUP BY

    Subject ;

Masaki

1 Reply
Employee
Employee

Re: Help me with script error

Hi,

You are using a QUALIFY statement, so you need to put "Inbox" before "Date Received" like this:

[MIN_INBOX]:

LOAD

    Subject,

    min([Inbox.Date Received] ) as [First Time Received]

RESIDENT [Inbox]

GROUP BY

    Subject ;

Masaki

Community Browser