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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Update does not work, please help

Hi, I'm new to QlikView and have the following problem:

                        

I get data from a SQL server using a query, the query result is placed in a table called DocPerso and whose details are shown to the user using one TableBox. I want to simulate an increase on one of the fields DocPerso then I create a button and add a dynamic  update action but when I click on the button nothing happens. Why the update does not work?


Scenario:

SQL Server souce of data.

Qlickview personal desktop (trial).

I have not installed QlikView Server.

Script:

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='h:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';

SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=admin;Initial Catalog=Salario_Perso;Data Source=SQL_WINSERVER;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SQL_WINSERVER;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is GHadeTdNSTcSGaROJDMA);

DocPerso:

SQL SELECT top 10 *

FROM Salario;

STORE DocPerso into C:\QLIK11\DocPerso.qvd (qvd);

Aditional information:

In the Main page "DocPerso" are shown by a "TableBox".

DocPerso has 3 fields: emp_id, Salary_Emp,Desc_Emp

As I have to simulate a salary increase of 10%, then I make a button with a dynamic update action with the following statement:

                                    "UPDATE DocPerso SET Salary_Emp = Salary_Emp*1.10;"

The document has the following options;

config_update.JPG

Resulting situation:

Clicking on the button to update data nothing happens, I need something more?

Thank you very much for the help you can give me.

PS: sorry if my English is not very good.

0 Replies