You can create a named range in the Excel sheet by including the header at BD45 and the value at BD46 in the range. Then it will appear in the list of tables for Qlik Sense when you load the Excel file.
So a load could look like this:
(ooxml, embedded labels, table is TOTAL);
Here I have named the range in Excel TOTAL.
i added this to auto generated section, and also to a new section in a new app.
I can see the "Total " in add expression filter in a KPI object. but there is no data in it, just " - " .
the excel valule in bf46 is formulated should that be the reason?
FROM [lib://Desktop/100. Concern Tracking List 2018.xlsx]
(ooxml, embedded labels, table is ConcernDataTable)
Where RecNo()>43 and RecNo()<45; (also i tried RecNo=45)