
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For Each Loop Limitation
Hi All,
I have recently faced one issue with "For Each Loop".
Let me explain the issue:
I got an error when I try to reload with n no. of sheets and I've written names for each sheet in a single line. Like this:
FOR EACH vSheet IN 'California','[New Jersey]','[Los Angeles]', many more sheets with City Names in it ............. there are n no. of sheets
I think qlikview has set limit for characters to be used in a single horizontal line which I think I've exceeded.
After fixed no. of characters, whatever I'm writing is coming to the next line.
So, the issue is that For Loop only accept the values written in the single line. Since, I've so many State & Country details so how to handle this scenario.
If someone has worked on such requirement than please let me know.
Regards,
Eric
- Tags:
- qlikview_scripting
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @erric3210
PFR
https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html
Hope above links will help you.
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @erric3210
PFR
https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html
Hope above links will help you.
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
