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

?

xyz1 — Sun, 14 Apr 2019 15:56:08 GMT

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

tresB — Mon, 23 Oct 2017 06:23:06 GMT

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

?

xyz1 — Sun, 14 Apr 2019 15:55:20 GMT

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

tresB — Mon, 23 Oct 2017 06:34:39 GMT

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.

?

xyz1 — Sun, 14 Apr 2019 15:54:27 GMT

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

tresB — Mon, 23 Oct 2017 06:57:04 GMT

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 — Sun, 14 Apr 2019 15:51:03 GMT

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

tresB — Mon, 23 Oct 2017 07:11:32 GMT

Yes, without that brackets for where clause, like

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

Isn't it working?

?

xyz1 — Sun, 14 Apr 2019 15:53:21 GMT

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

tresB — Mon, 23 Oct 2017 07:28:11 GMT

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;