Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.

Tags (1)
Community Browser