Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Input field syntax and inputsum vs. inputavg

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?



1 Reply
francesco_menin
Partner - Creator III
Partner - Creator III

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