Inserting value into a column of TableBox

Thu, 02 Oct 2014 08:13:23 GMT

Hello

I have a TableBox Object that loads with certain columns and data.

In a macro I need to be able to add a column to this TableBox, that I can do by

set tb = ActiveDocument.GetSheetObject("TB06")

tb.AddField("CampaignId")

But then in this column I need to insert a value for every row (every row will have the same value)

The reason I have to do this afterwards is because I have to insert some other data in a database and get an Id back before I can set the value of this column.

Is there a way of doing this?

Re: Inserting value into a column of TableBox

Gysbert_Wassenaar — Thu, 02 Oct 2014 08:32:15 GMT

There's a dynamic update action you may be able to use. From the help file:

Dynamic Update

Performs a dynamic update of the data in the currently loaded document. The statement for the dynamic update is to be entered in the Statement field.

The intended usage of Dynamic Update allows a QlikView Administrator to feed limited amounts of data in to a QlikView document from a single source without running a reload of the document. Analysis can then be performed by multiple clients connecting to the QlikView Server.

Note! The uploaded information is stored in RAM only so any data added or updated using Dynamic Update will be lost if a reload of the document is performed.

The following grammar describes the possible statements and their components that can be used with the Dynamic Update feature:

statements ::= statement { “;” statement }
statement ::= insert_statement | update_statement | delete_statement | begin_transaction_statement | commit_transaction_statement
insert_statement ::= "INSERT" "INTO" ("*" | table_name) field_list "VALUES" value_list {"," value_list} ["KEY" ["AUTO" | (" (" field_list ")")] ["REPLACE" (["WITH" "ONE"] | "EACH") ]]
update_statement ::= "UPDATE" ("*" | table_name) set_clause {"," | set_clause} "WHERE" condition ["AUTO" "INSERT"]
delete_statement ::= "DELETE" "FROM" ("*" | table_name] "WHERE" condition
begin_transaction_statement ::= "BEGIN" ("TRANSACTION" | "TRAN") [trans_name]
commit_transaction_statement ::= "COMMIT" ["TRANSACTION" | "TRAN"] [trans_name]
table_name ::= identifier | quoted_name
field_list ::= "(" field_name {"," field_name} ")"
value_list ::= "("value {"," value} ")"
set_clause ::= "SET" field_name "=" any_valid_non_aggregated_qlikview_expression
field_name ::= identifier | quoted string
value ::= identifier | any_qlikview_number | quoted string
condition ::= any_valid_non_aggregated_qlikview_expression
identifier ::= any_qlikview_identifier
quoted_string ::= "[" [^]]+ "]"

Example:

UPDATE AbcTable SET Discount = 123 WHERE AbcField=1

Note! To use this feature, Dynamic Update must be allowed both on the Document and on the Server.

topic Inserting value into a column of TableBox in QlikView

Inserting value into a column of TableBox

Re: Inserting value into a column of TableBox