InputField - Changing the top level value

[Dayna]

Hello All,

I'm very new to Inputfields, so excuse my ignorance if this is easily achieveable!

I have a field which mirrors the balance for each product where I change the value to reflect my 'whatif' scenario. This works fine..! My query, is how to change the behaviour when you change the top level - i.e. the Product Category or Customer.

So, lets say, a product belongs to category.. Now, when I change this value at the top level (i.e. the Category level) the amount I've changed it by is added/subtracted equally to all the products below. What I would like to do, is subtract the percentage of the change to each product. For example:

Category Total WhatIf Value
100 80

So I've changed the top level by subtracting 20%.. What QlikView would do now is subtract 10 from both products below it. What I want it to do is subtract 20% of each of the product total:

Product Total WhatIf Value
60 48
40 32

I've included an example of the inputfield with the category and products..

I hope you can help me!
Kind Regards,
Dayna

[Miguel_Angel_Baeyens · Accepted solution]

Hello Dayna,

In the Inputsum, use the following distribution mode:

InputSum(WhatifQty, '*')

That "*" means "distribute equally to underlying values". and it's not the default distribution mode. Go to the reference manual, pp 362 to find further about distribution modes in inputfields.

Hope this helps.

[Dayna]

Hello Miguel,

Once again, perfect!! Thank you!!

My reference manual seems to be out of date as I can't find anything about the distribution modes, would you mind sending me a copy?

Thanks again!

Dayna

[Miguel_Angel_Baeyens]

Sorry, I was referring to the v10 manual before noting your footer, look in yours for the InputSum(). Anyway, try this link. If this doesn't work I will upload it.

Regards.