Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @erric3210
PFR
https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html
Hope above links will help you.
Hi @erric3210
PFR
https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html
Hope above links will help you.