Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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