topic Re: VBscript - how to create a Generic list of type string in QlikView

VBscript - how to create a Generic list of type string

Mon, 26 Jan 2026 16:26:21 GMT

I need to create an Generic list of type String, that I want to fill with some values.

I tried the following statements

Dim sList
Set sList = CreateObject(“System.Collections.Generic.List[String]”)
sList.Add(“Read”)
sList.Add(“Stop”)

This is not working.

Can you please provide me with the correct code?

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Tue, 12 Jul 2016 10:41:14 GMT

What is your aim in the end? How should this string-list look like, from where should it be filled and what should be done with these list?

- Marcus

Re: VBscript - how to create a Generic list of type string

Tue, 12 Jul 2016 11:09:17 GMT

The code must be working when attached to a button in a QVW document that runs on the Qlikview accespoint with the AJAX engine.

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Tue, 12 Jul 2016 14:01:22 GMT

On this point is your macro-approach already out then within the ajax-client run no macros and especially not one which include a CreateObject() which required the use of ActiveX which is only within the desktop-client or the plugin available.

Therefore the question what do you want to do with these routine?

- Marcus

Re: VBscript - how to create a Generic list of type string

Tue, 12 Jul 2016 14:06:18 GMT

Marcus,

I would like to trigger the Function TriggerEDXTask with all parameters.

I've everything in place to trigger this function, except that I cannot define/create the variableValues As List(Of String)

Function TriggerEDXTask ( _

qdsID As Guid, _

taskNameOrID As String, _

password As String, _

variableName As String, _

variableValues As List(Of String) _

) As TriggerEDXTaskResult

So if I know how to fill the variableValues on a correct manner, it would be great.

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Tue, 12 Jul 2016 14:29:59 GMT

Are you sure that this is a vbs-example and that edx worked per vbs-macros?

- Marcus

Re: VBscript - how to create a Generic list of type string

Tue, 12 Jul 2016 14:33:36 GMT

The function as mentioned above is not a VB script example. It is just a copy out of the documentation of the API function, and there you can read that the value for the last parameter (variableValues) should be a generic list of type string.

So that's why I need to know how I can populate such a type of list.

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Tue, 12 Jul 2016 15:27:55 GMT

For this you could use concat() within the gui in a variable which you could read with a macro or within a macro it could be created with an evaluate() statement.

- Marcus

Re: VBscript - how to create a Generic list of type string

Tue, 12 Jul 2016 16:41:56 GMT

Hi Marcus,

thanks for the tips and help sofar, but unfortunately I still don't know exactly what to do. (I'm rater a newbee in VBscript)

I have done the following in the variable definitions

vCall1 = Read (via input box)

vCall2 = Copy (via input box)

vConcat = concat('$(vCall1)', '$(vCall2)') (via Variable definition)

When I put the variable vConcat in a text box (='$(vConcat)')) nothing is shown.

In the macro I try to read the variable vConcat with the following command

y = ActiveDocument.Variables("vConcat").getcontent.string

I have my doubts about the .string at the end of this read, but I don't know what to put else there.

The result is that y = empty

So what do I do wrong in this coding?

How can I use the evaluate() option in the Macro?

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Tue, 12 Jul 2016 17:25:46 GMT

Concat() is a string aggregation-function which you didn't need if you want only to concat strings from variables which you could concat with: '$(vCall1)' & ',' & '$(vCall2)'.

To execute qlik-functions from the macro-side you could use the following:

x = ActiveDocument.Evaluate("Concat(YourField, ',')")

whereby you could simply read your variables vCall1 + vCall2.

- Marcus

Re: VBscript - how to create a Generic list of type string

Tue, 12 Jul 2016 17:48:39 GMT

Marcus,

When I use the string 'Read, Copy' (without ') as values for the valuelist in the call, I get the following (unfortunately in Dutch) error message from the call:

---------------------------

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><s:Fault><faultcode xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher">a:DeserializationFailed</faultcode><faultstring xml:lang="nl-NL">Er is een uitzondering opgetreden in de formatter bij de poging het bericht Er is een fout opgetreden tijdens de poging parameter http://ws.qliktech.com/QMS/11/:variableValues te deserialiseren. Het InnerException-bericht is Fout in regel 1 positie 441. Status Element wordt verwacht.. Text met naam , naamruimte is aangetroffen. . Zie InnerException voor meer details. te deserialiseren.</faultstring><detail><ExceptionDetail xmlns="http://schemas.datacontract.org/2004/07/System.ServiceModel" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><HelpLink i:nil="true"/><InnerException><HelpLink i:nil="true"/><InnerException i:nil="true"/><Message>Fout in regel 1 positie 441. Status Element wordt verwacht.. Text met naam , naamruimte is aangetroffen. </Message><Stack

---------------------------

It is telling that during deserialise/evaluation of the parameter variableValues a wrong format was expected. A status element was expected and instead a string was found. So the string Read, Copy is not the correct format for passing on a generic list of type string.

With use of QMS API client (one of the QV powertools) a can start the EDX job and pass on a correct value for the variableValues that also in that tool is shown as List(String) and where I have to input the values with a separate screen in which Index 0, Type String and Value is shown and there I give in Value Read for the first line and value Copy for the second line. Unfortunately I cannot see in this tool how this list is passed to the API.

The only thing I now is that is must be a generic list of type String (so no Array or just a String).

Re: VBscript - how to create a Generic list of type string

Tue, 12 Jul 2016 19:05:46 GMT

Hi Marcus,

I get indeed an error in the QV VBscript editor telling me that it is not possible to use CreateObject() which required the use of ActiveX.

Is there a way to simulate the content of an generic list of type String? In any other format that i can create in the VB script? I only need to pass the first occurrence of this list.

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Wed, 13 Jul 2016 05:19:26 GMT

I think with a ListOfStrings is an array meant, maybe something like this:

a = ActiveDocument.Variables("vCall1").getcontent.string

b = ActiveDocument.Variables("vCall2").getcontent.string

c = array(a, b)

- Marcus

Re: VBscript - how to create a Generic list of type string

Wed, 13 Jul 2016 19:37:49 GMT

Marcus,

That's the big issue: a generic list of type String is not a normal Array. So this is not working.

Re: VBscript - how to create a Generic list of type string

Wed, 13 Jul 2016 20:33:48 GMT

Searching further on the forum, gives me this piece of information:

This is not an object that's specifically a part of the API code - it's .NET behavior. You haven't defined that generic object lists should be of the type List<>, but Array[]. Array[] does not have .Add, but List<> does.

If you got to the Solution Explorer > (Project) > Services References > (QMS backend) > right click > Service Reference Settings.. > Collection type. Set this to "System.Collections.Generic.List" instead. You might need to re-build the solution for this (Ctrl+Shift+B).

You could as well use Array[] if you are more comfortable with that, but in my opinion it will only limit usage of API object lists, since List<> is a very powerful enumerable collection.

I found this information in the following post:

QVS API Support

So if I understood this information correctly, it looks like that you need to change a setting on the server to make working with generic lists possible. If this is true, can someone please tell me exactly what I need to change? And where i can find this setting?

Re: VBscript - how to create a Generic list of type string

marcus_sommer — Thu, 14 Jul 2016 07:52:44 GMT

I think that this meant, that's not possible to use vbs for this and that you need to use visual studio like described here: Using EDX in QlikView 11 - basic example.

- Marcus