topic Re: For Each Loop Limitation in QlikView

For Each Loop Limitation

erric3210 — Sat, 16 Nov 2024 17:43:55 GMT

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

Re: For Each Loop Limitation

MayilVahanan — Tue, 08 Dec 2020 09:48:05 GMT

Hi @erric3210

PFR

https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-with-file-name/ta-p/1481095

https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html

Hope above links will help you.

Re: For Each Loop Limitation

erric3210 — Tue, 08 Dec 2020 23:01:02 GMT

hi @MayilVahanan

Thanks for sharing the links. It works for me.

Regards,

Eric