Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
I am trying to add an excel cell (BD column and row 46 which is a calculated value from a table) to qlik sense. I tried all i can find in forum but couldn't accomlished. I just want to see the calculated value in BD column and row number 46. Can anybody help me with this?
BD
TOTAL |
---|
1.3664555 |
The value is at row 46
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:
LOAD
"TOTAL"
FROM [lib://Documents/BD46.xlsx]
(ooxml, embedded labels, table is TOTAL);
Here I have named the range in Excel TOTAL.
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:
LOAD
"TOTAL"
FROM [lib://Documents/BD46.xlsx]
(ooxml, embedded labels, table is TOTAL);
Here I have named the range in Excel TOTAL.
Hi,
Try below code:
LOAD
TOTAL
FROM
[BD.xlsx]
(ooxml, embedded labels, table is Sheet2)
Where RecNo()>45 and RecNo()<47
thanks i'll try this
thanks i'll try this
thanks i'll try this
why we can't do?
Where RecNo()=45
Hi
Yes we can do Where RecNo()=45 also
hello
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?
[ConcernDataTable]:
LOAD
[TOTAL]
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)
Pl attach your excel here