Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Store Excel Values in variables

Hi,

I have got a spreadsheet with some values stored in a column. Now I need to extract this into Qlikview and store the values of different rows of the column into separate variables in Qlikview.

How do I do that?

Cheers

1 Solution

Accepted Solutions
Highlighted

Store Excel Values in variables

ExcelData:

LOAD Field FROM [File.xlsx] (ooxml, embedded labels);

Let vVariable1 = peek('Field',0,''ExcelData'); // Row 1

Let vVariable2 = peek('Field',1,''ExcelData'); // Row 2

View solution in original post

3 Replies
Highlighted

Store Excel Values in variables

ExcelData:

LOAD Field FROM [File.xlsx] (ooxml, embedded labels);

Let vVariable1 = peek('Field',0,''ExcelData'); // Row 1

Let vVariable2 = peek('Field',1,''ExcelData'); // Row 2

View solution in original post

Highlighted
Not applicable

Re: Store Excel Values in variables

That worked.. Thx!!

Highlighted

Re: Store Excel Values in variables

Here is an example that shows how I mean. Put both files in the same folder and it will work. The script also contains a loop that you can use if you want to define both Names and Values of the variables in the Excel sheet.

/HIC