Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loop inline table

Hi,

I have a script which sends by email a report to several users, I don't wnat to put the list of users hardcoded in the script. For that reason I've created an inline table with the users email.

The main problem is I don't how to loop through the inline table in the visual basic script code.

Can anyone give me some examples? Or does anyone know other way to avoid to put the user mail list in the code?

Thanks.

2 Replies
Gabriel
Valued Contributor II

Re: Loop inline table

Hi,

What I will look to do is store the inline table into QVD then drop the inline table. Meaning I can then loop through the table from QVD file.

You can then use

For i = 0 TO NoOfRows('TableName') -1

     Actions you want here

Next i

Hope this helps

Actaully you can Loop through your data island as well you don't have to store it as QVD.

Not applicable

Re: Loop inline table

Thanks for the answer, I'm going to try your suggestion.

Thaks.

Community Browser