Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic field, extendible with VB script

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...

3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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??

Not applicable
Author

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

It works now...

Thanks Oleg!!