topic Re: loading 1 cell value in QlikView

loading 1 cell value

Wed, 01 May 2013 10:40:20 GMT

HI All,

i have a value in file.XLSM in one cell

for eg cell C2 has a value of 10

i need to load value 10 in my script and store in a variable called test

please advise if possible

thanks

Re: loading 1 cell value

Wed, 01 May 2013 10:47:29 GMT

Hi matharasu,

Sounds like a very specific question, for a broader problem...

What exactly is your problem? I think you can just load the value of cell2 into qlikview (or is that already the problem)?

When done, you can store it in a variable with this code:

let test=peek(Fieldname [ , Row [ , TableName ] ] )

Hope it helps.

Good luck!

Re: loading 1 cell value

Wed, 01 May 2013 10:50:59 GMT

the problem is the sheet present in file.xlsm contains lot of other information which is not relevant

thus is there a way to load a specific cell from a sheet.

thanks

Re: loading 1 cell value

Anonymous — Wed, 01 May 2013 10:54:11 GMT

Hi Matharsu,

Can You Share the test data file for same.

Re: loading 1 cell value

Wed, 01 May 2013 10:55:06 GMT

load

columnname

from tablename.xslm

where columnname = '10';

Let test = columnname;

Re: loading 1 cell value

er_mohit — Wed, 01 May 2013 10:57:10 GMT

load a,

b, value

from table

where exists(value=10);

Re: loading 1 cell value

Wed, 01 May 2013 11:00:31 GMT

I just tested. It is no problem. Just load your data from excel using the wizard in the loadscript for loading the first table. Usw rowno() for determining which row you need and then you have your data.

This is the script i used.

testExcelTemp:

LOAD

RowNo()as row,

FROM

x.xlsx

(ooxml, no labels, table is Sheet1) ;

NoConcatenate

Final:

load J

resident

testExcelTemp

where row = 11;

drop table testExcelTemp;