topic Re: Qlikview Personal Edition - dynamic update in QlikView

Qlikview Personal Edition - dynamic update

Tue, 05 Jan 2016 01:43:18 GMT

Saludos ante todo....quisiera saber si en el Qlikview Personal Edition (v12) es posible la actualización dinámica, el escenario que estoy usando a fines de aprendizaje consta de una tabla que es presentada mediante un TableBox con un par de campos numéricos y mediante un botón al que he agregado una acción de "Actualización Dinámica" (en las opciones del documento he tildado permitir actualización dinámica) quiero actualizar la columna "precio" en "precio x 1.21" pero no se actualiza la columna, a que se debe?

Solo tengo instalado la version de prueba del Qlikview Personal Edition sin versión server ni nada por el estilo, es debido a esto?

Desde ya muchas gracias por la ayuda que me puedan brindar.

Greetings.... I want to know if the QlikView Personal Edition (v12) is possible dynamic update, the scenario I'm using for learning purposes consists of a table which is presented by a TableBox with a pair of numeric fields and by a button to which I have added an action of "dynamic Update" (in the document options I enable dynamic update) I want to update the "price" column in "price x 1.21" but the column is not updated, why dont update ?

I have just installed the trial version of QlikView Personal Edition without server version or anything else, it's because of this?

thank you very much for the help me.

Re: Qlikview Personal Edition - dynamic update

Gysbert_Wassenaar — Wed, 06 Jan 2016 18:21:52 GMT

It's not a limitation of Qlikview Personal Edition. Perhaps your update statement is not correct. Perhaps the help entry gives a clue: QlikView ‒ Add Action dialog

Re: Qlikview Personal Edition - dynamic update

Thu, 07 Jan 2016 04:35:52 GMT

thank you very much for answering!!!! .... I could not even accomplish anything .... I made a new simple script to find because no dynamic update works;

Scenario:

SQL Server souce of data.

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.