Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

Field not found error in resident load

hi,

For the following script I am getting field not found error:

[Max_Dim_time]:
load date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time" resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;

I have traced that for this portion of code : order by "Max_Upd_Time" DESC i am getting error.

Please help me for this.

Thanks,

Sandip

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You can't use a field in the Order By clause which is being created in the same load. Try creating your "Max_Upd_Time" field in the previous load and then try like:

[Dim_Office_Updated_Date]:
load           [UPD_TS],

               date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time"

from $(vExtractPathName)\Dim_Office.qvd(qvd);


[Max_Dim_time]:

Order

load "Max_Upd_Time"

resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;

View solution in original post

3 Replies
Anil_Babu_Samineni

Can you send full script. I mean before resident load file

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ananyaghosh
Creator III
Creator III
Author

[Dim_Office_Updated_Date]:
load [UPD_TS] from $(vExtractPathName)\Dim_Office.qvd(qvd);

[Max_Dim_time]:
load date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time" resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;

tresesco
MVP
MVP

You can't use a field in the Order By clause which is being created in the same load. Try creating your "Max_Upd_Time" field in the previous load and then try like:

[Dim_Office_Updated_Date]:
load           [UPD_TS],

               date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time"

from $(vExtractPathName)\Dim_Office.qvd(qvd);


[Max_Dim_time]:

Order

load "Max_Upd_Time"

resident [Dim_Office_Updated_Date] order by "Max_Upd_Time" DESC;