topic Re: Scenario Analysis - High Level Input Field in QlikView

Scenario Analysis - High Level Input Field

Wed, 17 Aug 2011 19:00:34 GMT

I'd like to be able to create a fairly simple scenario analysis where the user can enter a percentage into an input box and see the affect on sales.

Inputfield sort of gives me what I want, but I need to be able to makes changes at a higher level. For example, if Brand_A increases by 15% or ProductLine_W descreases by 5%, what will the total sales be? I need the 15% to affect all products under Brand_A without having to key several numbers in.

Anyone have any idea?

Thanks,

Justin

Re: Scenario Analysis - High Level Input Field

Wed, 17 Aug 2011 19:42:48 GMT

I updated your example, very basic but hopefully this will get you headed in the right direction! Just adjust the slider to effect the forecast numbers.

Re: Scenario Analysis - High Level Input Field

Wed, 17 Aug 2011 19:49:49 GMT

Thanks, Leonard, but what I amlooking for is to be able to adjust only Brand_A by x%, leave all others as they are, and see the impact on sales.

I guess I'm kind of looking for a way to do a mass update or change of input fields based on the brand or product line selected.

Re: Scenario Analysis - High Level Input Field

Wed, 17 Aug 2011 20:15:47 GMT

Simple enough, try this version out.

Re: Scenario Analysis - High Level Input Field

Wed, 17 Aug 2011 21:00:08 GMT

Thanks again, Leonard. And while that example does give me exactlywhat I asked for, I need to it on a much larger scale with hundreds ofbrands and product lines.

I thought about creating variables in my script foreach brand and product line but as far as I know, there's no way tosearch for a specific variable.

I want the user to beable to pick Brand_A from a list box and simply increase everythingunder that brand by 10 percent. Then pick Brand_D from a list box anddecrease everything for only that brand by 5 percent. Or do the same ifa product line needed to be changed.

I have an example of how I want it to be in the end, but I don't see how I can add an attachment to a reply. I had to key in the values that I wanted for each individual product in the tablebox. This is fine if there are only a few items,but I have thousands and I need a way to be able to select a group ofitems and adjust them.

How do I add an attachment to a reply?

Re: Scenario Analysis - High Level Input Field

Wed, 17 Aug 2011 21:16:44 GMT

After you hit reply, click the 'Use advanced editor' in the upper right corner of the reply box & you can attach a file.

I think the attached file is a bit closer yet to where you want to go