Load Script from other sections

[francisco_cohen]

Hi all,

I'm using qlik sense desktop.

In my script I have 3 sections:

Section 1 : Projects

[Project]:

load

     "project code",

     'value",

FROM [lib://Fsbox/Financial data\Projects.xlsx]

(ooxml, embedded labels, header is 6 lines, table is [Projects]);

Section 2: Owners

[Owners]:

load

     "project code",

     "project owners"

FROM [lib://Fsbox/Financial data\Project owners.xlsx]

(ooxml, embedded labels, header is 6 lines, table is [Projects]);

In section 3 I want to load a new table that shows only projects with a value greater than 1000 with fields loaded in section 1 and 2. How should I whrite this script?

Section 3: Report

[FINAL]:

laod

     if("value">1000,

     "project code",

     "value",

     "project owners"

from ?!?!?!

Thank you,

FC.

[Anonymous]

Looks like you need a Resident load :

     Loading data from a previously loaded table ‒ Qlik Sense

[francisco_cohen]

Is there any example that you can send me in qvf format?

[Anonymous]

Maybe {hopefully?} something like this.  I have typing it freehand and as untested quite likely to have some typo's:

[Project]:

load

    "project code",

    'value"

FROM [lib://Fsbox/Financial data\Projects.xlsx]

(ooxml, embedded labels, header is 6 lines, table is [Projects]);

[MapOwners]:

mapping

load

    "project code",

    "project owners"

FROM [lib://Fsbox/Financial data\Project owners.xlsx]

(ooxml, embedded labels, header is 6 lines, table is [Projects]);

[FINAL]:

load

    "project code",

    applymap('MapOwners' , [project code])  as [Project Code] ,

    "value"

resident [Project]

where [value] >1000 ;

drop table Project ;

If you have not come across Mapping Load / ApplyMap() before then check them in the Online Help