topic Re: Dynamic Update from InputField in QlikView

Dynamic Update from InputField

sebastiandperei — Tue, 29 Oct 2013 00:15:11 GMT

Hi All.

I need to update field1 with values from field2, but the problem is that the field2 is an InputField. Is it possible?

How can i do that?

Re: Dynamic Update from InputField

Tue, 29 Oct 2013 02:35:13 GMT

Hi,

Inputfield is pointing to a variable, then the sql statement just to call the variable.

Re: Dynamic Update from InputField

sebastiandperei — Thu, 14 Nov 2013 20:44:25 GMT

Thanks CS!

But my field has +1000 values, i don't want to create 1000 UPDATE sentences.

Finally, i have resolved with Dynamic Update Macro.

Re: Dynamic Update from InputField

Fri, 13 Dec 2013 21:22:07 GMT

Hello Sebastian,

I've the same issue. I've couple of input fields, whcih I am using to calculate FIELD(Z). I want to modify FIELD(Z) as I input new values.

Example:

Field-A Field-B Field-C Field-D (Field-C is input capable)

10 2 .20 10 * 2 * (1 - 0.2) = 1.6

Now I'm going to change Field-C from 20% to 50%

10 2 .50 10 * 2 * (1-.5) = 1.0 ---NEW VALUE (How do I achieve this)

I want the user be able to play with few attribute to see how it affects their Sales.

Prabha

Re: Dynamic Update from InputField

sebastiandperei — Mon, 16 Dec 2013 17:56:29 GMT

Hi Prabha,

You should use a Pivot or Straight Table. Field-A, B and C as Dimmentions, but field D must be an expression.

Create an expression like:

Field-A * Field-B * (1 - Field-C)

If i didn't understood, please send the qvw.

Re: Dynamic Update from InputField

licciardello — Mon, 12 Jan 2015 09:30:24 GMT

sebastiandpereira

Hi,

First sorry for my English ...

I need to do an update of many records, after changing a field inputsum ([Invoice Amount]).

I change the total value with the function inputsum (). The value of inputsum ([Invoice Amount]) is divided into n records correctly.

Then I do update the field [Corrected Invoice Amount]) on n records, using the value of the field [Amount Invoice].

On only one record I can do it, but for many records I do not know how. Should I use a macro, but do not know them well.

Can you help?

Thank You.

Re: Dynamic Update from InputField

sebastiandperei — Thu, 29 Jan 2015 13:27:37 GMT

Hi Roberto.... In Spanish is better?

I suggest to you to create a new post, all the people will give more attention to a new post!

Te sugiero que empieces un nuevo post, así la gente le presta más atención y colabora con la solución.

Re: Dynamic Update from InputField

perla_chirag — Thu, 04 Feb 2016 12:52:54 GMT

Seb, I think Roberto is Italian.

Roberto, Suggerisco a voi per creare un nuovo post , tutte le persone che daranno maggiore attenzione a un nuovo post