Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Reference Absolute Cell Value in Excel

Hello. I'm using a LOAD statement to read data from Excel. I'm having to use explicit labels, so my script looks like LOAD A, C, AC, etc. Is there a way to reference the value of a cell -- say J1, B3, etc? My searching makes me think such functionality was not available in older version of QlikView, but I'm hoping something has changed. Thanks.

1 Reply
Not applicable

Re: Reference Absolute Cell Value in Excel

There are several ways, but QV is not a spreadsheet program so don't expect the ease of excel. One way is to define that one cell in excel as a named range, aka table. You can then in QV load only that table. Another way is to load only the column that contains the cell, set the header to xxx rows to skip all the rows above the one that contains the cell and put FIRST 1 directly above the load statement to load only 1 record.

talk is cheap, supply exceeds demand