0 Replies Latest reply: Jan 7, 2016 4:23 PM by juan gorras RSS

    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.