Documents for QlikView related information.
Dynamic Update is a few feature QlikView is offered to modify the data after QlikView gets reloaded. QlikView is a Data analytics tool, but you can keep it has simple database.
Using dynamic update:
1. Add records to the existing table.
2. Update the records in the table.
3. Delete few records from the table.
Syntax is just like SQL
INSERT INTO TableName(Fieldlist) VALUES(Valueslist);
UPDATE TableName SET FieldName = value WHERE ConditionalField = Condition
DELETE FROM TableName WHERE ConditionalField = Condition
I have uploaded the QlikView file Here
Settings to enable
QVW: Document properties --> Server tab--> Enable Dynamic Data update See below
Server: QMC-->System-->Setup-->QVS-->Security--> Enable Allow dynamic data update
Yeah , its wonderful celam for beginners who are awaiting for a demo.
When we update(insert ,delete or update) a table like this ,can we revert this updation in the database table
bcz I have seen an option in edit screen, settings tab which is last tab in the second pane stating
"open database in read and write mode"
That option is to use insert/update/delete commands in script. Not from front end.
You mean "SQL select" statement of load command, then what about the security to the database,
I think even if we opt for the option at the database server end there may be restriction.
Can u elaborate it??
This is a really great and usefull function!Major drawback is, that users who want to add or update data, need to be in QlikView Administrators group.....
I hope Qlik will change that some day, by making a special group "Qlikview dynamic update" for example!
What will happen if multiple users are accessing this dashboard and are adding/deleting/updating records. Do all these users sees all changes made by each other on their client view?
do you know whether this SQL syntax allows for joins? If yes, can you give an example?