Input field syntax and inputsum vs. inputavg

Fri, 18 Mar 2011 11:31:09 GMT

Hello,

I have been trying to work out a way to use the relatively new syntax for inputation in combination with inputavg(field,'*').

What has been happening to me is that when I try to input some value in an inputfield with the "%+n" or "=+n" syntax, the field automatically switches to an inputsum mode, changing the underlying value to that of the correspondent inputsum value.

"customer" "qty" "price inputsum" "price inputavg"

1 2 500 250

2 1 300 300

3 5 1000 200

4 2 2500 1250

after adding a %+10 on the prices:

"customer" "qty" "price inputsum" "price inputavg"

1 2 550 550

2 1 330 330

3 5 1100 1100

4 2 2750 2750

that was supposed to be:

"customer" "qty" "price inputsum" "price inputavg"

1 2 550 275

2 1 330 330

3 5 1100 220

4 2 2750 1375

has anybody experienced this? do I have to resort to adding another column to insert the % instead of directly modifying the value on the inputavg field?

Re: Input field syntax and inputsum vs. inputavg

francesco_menin — Thu, 17 Jul 2014 12:42:18 GMT

has anybody answered this yet? I think this is still true with 11.2 SR5

topic Input field syntax and inputsum vs. inputavg in QlikView

Input field syntax and inputsum vs. inputavg

Re: Input field syntax and inputsum vs. inputavg