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?
SQL Server souce of data.
Qlickview personal desktop (trial).
I have not installed QlikView Server.
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';
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);
SQL SELECT top 10 *
STORE DocPerso into C:\QLIK11\DocPerso.qvd (qvd);
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;
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.