Discussion Board for collaboration related to QlikView App Development.
how to retrieve row 3 from a table in a script,and assign column values to variables
You can do this
WHERE RowNo() = 3;
What exactly are you looking to assign to variable?
View solution in original post
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