Maybe I should explain i bit more what my situation is.
Ik have created an Excel file where the end user can set some settings.
For example one the settings is which container area's should be marked as an private area.
So the Excel file looks like this
Area 16, 17a, 18, 19-C, 20, 92
In my load script I'm using a function to put those values into a variable.
These variables a use a lot in Set Analysis.
I hope I could answer tour question
The values came from an Excel file and in my load script I put these values in a variable.
ID AS IKEASetupID,
Setup AS Setup,
Chr(39) & Replace(Replace(Value,' ','')
,',',Chr(39) &','&Chr(39)) & Chr(39) AS SetupValue
(ooxml, embedded labels, table is Setup);
LET vContainerArea = Peek('SetupValue', 0, 'Setup');
The variables I create in the above example are used very much in my calculations with Set Analysis.
The number of persons in mij example are the number of persons who has Access to that Area (House No).
Thanks for your help
No, you can't.
QlikView just substitutes '16', '17a' instead of $(vContainerArea) so that it becomes =ValueList('16', '17a')
It's incorrect syntax without the quotes.
I think you could use subfield function to split the string without the quotes directly in script:
Subfield(Peek('SetupValue', 0, 'Setup'), ',') as fContainerArea