topic InputField - Changing the top level value in QlikView

InputField - Changing the top level value

Dayna — Wed, 23 Mar 2011 09:26:02 GMT

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

InputField - Changing the top level value

Miguel_Angel_Baeyens — Wed, 23 Mar 2011 09:49:14 GMT

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.

InputField - Changing the top level value

Dayna — Wed, 23 Mar 2011 10:48:53 GMT

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

InputField - Changing the top level value

Miguel_Angel_Baeyens — Wed, 23 Mar 2011 11:03:15 GMT

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.