topic dynamic field, extendible with VB script in QlikView

dynamic field, extendible with VB script

Fri, 30 Apr 2010 08:49:43 GMT

Hi,

does anybody know if there is a possibility to have kind of a dynamic field, where I can add and remove elements with VB script at runtime. The user should see the field with an sheet object.

Somehow I need to show existing sheet objects and tables which I created by VB script to the user and where he could select one...

Any advice for the realization would be helpful...

dynamic field, extendible with VB script

Oleg_Troyansky — Fri, 30 Apr 2010 11:32:17 GMT

If you are using version 9, look in the APIGuide for the new API "DynamicUpdateCommand" and follow the example.

dynamic field, extendible with VB script

Fri, 30 Apr 2010 13:16:11 GMT

Thanks, trying it i had a problem

I did the following:

in the load script:

Test:
LOAD * INLINE [
TestTest
Sheet1
];

when I execute the statement:

set result = ActiveDocument.DynamicUpdateCommand("INSERT INTO * (TestTest) VALUES (asd)")

qlikview marks the line such as it is an Error but doesn't give me an error message. Do you know what wrong is??

dynamic field, extendible with VB script

Fri, 30 Apr 2010 16:08:40 GMT

I forget to set EnableDynamicDataUpdate=true in the document properties.

It works now...

Thanks Oleg!!