topic Set variable with table content in QlikView https://community.qlik.com/t5/QlikView/Set-variable-with-table-content/m-p/187041#M50876 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can I set a variable with a row?</P><P>Something like this:</P><P>TABLE:</P><P>LOAD ID;</P><P>SQL SELECT ID FROM TABLE1 WHERE ID=1;</P><P>Set variable = ID</P></BODY></HTML> Mon, 14 Jun 2010 10:21:29 GMT 2010-06-14T10:21:29Z Set variable with table content https://community.qlik.com/t5/QlikView/Set-variable-with-table-content/m-p/187041#M50876 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How can I set a variable with a row?</P><P>Something like this:</P><P>TABLE:</P><P>LOAD ID;</P><P>SQL SELECT ID FROM TABLE1 WHERE ID=1;</P><P>Set variable = ID</P></BODY></HTML> Mon, 14 Jun 2010 10:21:29 GMT https://community.qlik.com/t5/QlikView/Set-variable-with-table-content/m-p/187041#M50876 2010-06-14T10:21:29Z Set variable with table content https://community.qlik.com/t5/QlikView/Set-variable-with-table-content/m-p/187042#M50877 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>look for</P><P>LET vID = Peek('ID', 0, 'TableName');</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Mon, 14 Jun 2010 10:25:45 GMT https://community.qlik.com/t5/QlikView/Set-variable-with-table-content/m-p/187042#M50877 2010-06-14T10:25:45Z