Discussion Board for collaboration on QlikView Scripting.
how to retrieve row 3 from a table in a script,and assign column values to variables
Go to Solution.
You can do this
WHERE RowNo() = 3;
What exactly are you looking to assign to variable?
LET Var = Peek('Table2',2);
the value of first clounm for exemple
Should be able to use Peek() function
Let vVal = Peek('ColumnName', -1, 'TableName');
thank you sunny
No problem at all, always glad to help