Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francisco_cohen
New Contributor III

Load Script from other sections

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.

3 Replies

Re: Load Script from other sections

francisco_cohen
New Contributor III

Re: Load Script from other sections

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

Re: Load Script from other sections

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

Community Browser