Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikNewLearner1
Contributor
Contributor

Issue with using Resident Load

Hi All,

I'm new to this community. I'm trying to do a simple resident load but Qlik simply won't let me. I have used resident load 3 other times in my script but this one time it just does not work with Qlik throwing an error: Unknown statement: RESIDENT TransactionTableTemp.

Can anyone help please?

[TransactionTableTemp]:
LOAD "STOCK_CODE" As "Stock Code",
"PROCESS_DATE" As "Process Date",
"QUANTITY_ISS" As "Issue Qty",
"ISSUE_REQ_NO" As "Requisition No.",
"WORK_ORDER" As "Transaction Work Order",
"IREQ_TYPE" As "Requisition Type";

SQL "SQL codes";

[Stock Code Age]:
LOAD "Stock Code",
MIN("Process Date") As "Days Since First Receipt";
Resident [TransactionTableTemp]
GROUP BY "Stock Code";

DROP Table [TransactionTableTemp];

Thanks in advance!

Labels (1)
1 Solution

Accepted Solutions
JuanGerardo
Partner
Partner

There is a typo in your code. Just remove the semicolon before Resident (below in red):

Stock Code Age]:
LOAD "Stock Code",
MIN("Process Date") As "Days Since First Receipt";
Resident [TransactionTableTemp]
GROUP BY "Stock Code";

JG

View solution in original post

3 Replies
JuanGerardo
Partner
Partner

There is a typo in your code. Just remove the semicolon before Resident (below in red):

Stock Code Age]:
LOAD "Stock Code",
MIN("Process Date") As "Days Since First Receipt";
Resident [TransactionTableTemp]
GROUP BY "Stock Code";

JG

View solution in original post

QlikNewLearner1
Contributor
Contributor
Author

Thanks! Rookie mistake 🙂

MarcoWedel

Hi,

please close your thread by accepting an answer as solution.

thanks

Marco