topic get value of variable in script in QlikView

get value of variable in script

Thu, 26 Nov 2009 04:13:56 GMT

Hey Guys

I have a question for yours

i need read a variable from a load something likes this

LOAD [Group],
Name,
Frequency,
Tipe,
sheet1 //+++++this a read variables
FROM C:\Repository\frecuency.xls (biff, embedded labels, table is Hoja1$)
WHERE(Name)='$(File)';

var = sheet ; //+++++must be read value of variable

When i run this test , return a null value

Any help please !!!!!!

Thanks

get value of variable in script

Thu, 26 Nov 2009 04:24:10 GMT

Now sure if it is just a typo, but you load field 'sheet1' and set the variable to the content of field 'sheet'.

get value of variable in script

Thu, 26 Nov 2009 04:35:04 GMT

Hi Mark thanks for answer so soon

Yes a try to set content of the field 'sheet1' in to variable var

Thanks in advance

get value of variable in script

Thu, 26 Nov 2009 05:12:07 GMT

You won't be able to fill one variable with all the content of field 'sheet1', since that field will probably contain more than one value. A variable can only contain one value at a time.

get value of variable in script

Anonymous — Thu, 26 Nov 2009 09:25:56 GMT

If sheet1 has the same value for every row or if you want to pick a specific row value from sheet1 you can use peek() to pull it into a variable:

Let vVariable = peek('sheet1',-1,'TableName');

The second parameter is set to -1 which means the very last row. 0 is the first row and n is the n:th row. Any negative value starts from the bottom of the table and goes backwards. Hope this makes sense.