topic Loading a field as a variable in QlikView

Loading a field as a variable

Mon, 30 Nov 2009 18:44:52 GMT

Is it possible to set the value of a variable to the value of a field loaded from a qvd?

e.g.

LOAD

field1

FROM

file.qvd;

SET variable = field1;

When I do this the variable returns the text field1 as opposed to the value in field1.

Loading a field as a variable

prieper — Mon, 30 Nov 2009 19:11:34 GMT

You need to use the PEEK-command, like

SET variable = PEEK('field1', 0, 'MyTable')

This would load the first record, you may sort the table accordingly or create a special table with MIN- or MAX-values.

HTH
Peter

Loading a field as a variable

Mon, 30 Nov 2009 19:31:36 GMT

Thank you.

Re: Loading a field as a variable

Fri, 21 Sep 2012 15:54:56 GMT

Hi Peter, I am using the LET variable = PEEK('field1', 0, 'MyTable') syntax for a field that has only one value and row. For some reason it is not giving a value for the variable. Am I missing something?