3 Replies Latest reply: Sep 21, 2017 11:18 AM by Bill Markham RSS

    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.