topic Re: Creating a list variable in QlikView

Creating a list variable

Wed, 11 Nov 2015 14:56:48 GMT

Hey guys,

I have an excel WB with about 20 sheets, for each i need to use the same loading script,

is there a way to predefine a variable to hold a list of my sheet names so i can iterate over that list with a for loop load?

Thanks!

Re: Creating a list variable

Gysbert_Wassenaar — Wed, 11 Nov 2015 15:16:17 GMT

See this discussion: Loading Multiple Excel Files and Multiple Excel sheets

Re: Creating a list variable

miguelbraga — Wed, 11 Nov 2015 15:18:49 GMT

Hi Shahar Rosen,

If the sheets have a logical correlation you can create a for loop to read them and load values dinamically. Can you share a sample of your Excel file?

Regards,

Re: Creating a list variable

Wed, 11 Nov 2015 15:44:23 GMT

Ok i actually managed to create a list variable like this:

SET vSheetList = 'salary', 'bonus', 'car'..... ;

and then i iterate over that list...

and that works just fine