Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.