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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rzenere_avvale
Partner - Specialist II
Partner - Specialist II

InputField and Inputsum(): round the value, distribute proportionally and knowing which value has been modified

Hi everyone,

I have a couple of questions for you today.

1) I'm looking for a way to round the value when using the inputsum() function.

My problem is that I need to use the inputsum on a product hierarchy, starting from a product group and then splitting the input value on the underlying products.
I've seen that this works, but the value is not round (which is, talking of volumes, a very big problem).

Is there a way to make the inputsum split the value rounding it?

Note: using the "integer" option on the Number menu of the table is not what I'm looking for!

2) Similar to the previous question, is there a way to tell the inputsum() function to split the values on the underlying products proportionally to another field (which contains, i.e., a %)?

3) Last one: is there a way to know which value of an InputField has been modified from the user?

Thanks in advance

0 Replies