Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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