Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

xyz1
Contributor III

?

.

1 Solution

Accepted Solutions
MVP
MVP

Re: how to select data if tables are placed below main data table.

This is working for me:

LOAD

    "Month",

    "Forecast CAPEX",

    "Forecast GFC",

    "Initial CAPEX",

    "Initial GFC"

FROM [lib://aaa/trash.xlsx]

(ooxml, embedded labels, header is 16 lines, table is Sheet1) where RecNo()<13;

9 Replies
MVP
MVP

Re: how to select data if tables are placed below main data table.

You could probably increase/decrease the Header size to browse to different table in the same sheet.

Capture.JPG

xyz1
Contributor III

?

.

MVP
MVP

Re: how to select data if tables are placed below main data table.

If this is a static data source you could put a condition for upper tables to tell how far (may be row count) to fetch the data for that specific table. May be like:

Load

          *

From [lib://....] Where RecNo()<100;

Or you may put a flag in between to check to put a break in the load.

Highlighted
xyz1
Contributor III

?

.

MVP
MVP

Re: how to select data if tables are placed below main data table.

No. I meant to insert a static value for your fist column. But that would not be an easier option I realize. So better stick with the row count method if that solves your purpose.

xyz1
Contributor III

?

.

MVP
MVP

Re: how to select data if tables are placed below main data table.

Yes, without that brackets for where clause, like

FROM [lib://Trend/Trend.xlsm] Where RecNo()<12 ;

Isn't it working?

xyz1
Contributor III

?

.

MVP
MVP

Re: how to select data if tables are placed below main data table.

This is working for me:

LOAD

    "Month",

    "Forecast CAPEX",

    "Forecast GFC",

    "Initial CAPEX",

    "Initial GFC"

FROM [lib://aaa/trash.xlsx]

(ooxml, embedded labels, header is 16 lines, table is Sheet1) where RecNo()<13;