Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Scipt

Hi All ,

Can someone please explain me the below script

IF isNull(fileSize('$(vExcelPath)$(vfile_EC_Compliance)*.xlsx'))THEN

[RAW DATA]:

LOAD

    iEvalID,

    iFormID,

    Date,

FROM $(vQVDPath)RAW.qvd

(qvd);

DIRECTOR:   

    LOAD * FROM $(vQVDPath)DIRECTOR.qvd(qvd);

exit script;

   

Else

Get_File:

load

    FileName() as excels,

  mid(FileName(),34,6) as Year_Month,

EndIf

Max_Download:

load

max(Year_Month) as Max_Year_Month,

MAX(%FileNo) as %MaxFileNo,

MAX(Year_Month_Week) as %Year_Month_Week

Resident Get_File;

Thanks in advance

1 Solution

Accepted Solutions
willbleksem
Contributor III
Contributor III

Hi John,

This is a procedure used to load data.

It looks at the COmpliance excel file. and checks if it contains data or not. If it does, it will load the data from there.

If not, it then goes to a raw data file called DIRECTOR.qvd ans RAW DATA.qvd

inside of it, it takes the month and year of a certain period defined in one of your variables, filters it out ,combines it and creates its own data table for the qvw to read.

Hope this makes sense.

View solution in original post

2 Replies
willbleksem
Contributor III
Contributor III

Hi John,

This is a procedure used to load data.

It looks at the COmpliance excel file. and checks if it contains data or not. If it does, it will load the data from there.

If not, it then goes to a raw data file called DIRECTOR.qvd ans RAW DATA.qvd

inside of it, it takes the month and year of a certain period defined in one of your variables, filters it out ,combines it and creates its own data table for the qvw to read.

Hope this makes sense.

jmvilaplanap
Specialist
Specialist

Hi

I think there is not the complete script, because is doing reference to things that are not here.

And at the end of the script, use the Get_File resident table, but no always it will be created, depending if the xlsx file exist or not.

Get File table is not complete, because need a resident or autogenerate or something to be created. Is it working? I think is not possible.