Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

load scripting

how to retrieve row 3 from a table in a script,and assign column values ​​to variables

row<--table[2]


x<- row.fiels

1 Solution

Accepted Solutions
sunny_talwar

You can do this

LOAD FIELDNAMES

FROM ...

WHERE RowNo() = 3;

What exactly are you looking to assign to variable?

View solution in original post

6 Replies
sunny_talwar

You can do this

LOAD FIELDNAMES

FROM ...

WHERE RowNo() = 3;

What exactly are you looking to assign to variable?

View solution in original post

Anil_Babu_Samineni

Perhaps this?

LET Var = Peek('Table2',2);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
souadouert
Specialist
Specialist
Author

the value of first clounm for exemple

sunny_talwar

Should be able to use Peek() function

Let vVal = Peek('ColumnName', -1, 'TableName');

souadouert
Specialist
Specialist
Author

thank you sunny

sunny_talwar

No problem at all, always glad to help