What-If Analysis (Detail Level)

Sat, 24 Oct 2009 02:58:36 GMT

Hello guys,

I'm trying to implement a what-if analysis option on an existing Qlikview Report.

The existing Qlikview Report was designed to measure the purchase savings across various suppliers during a particular time period. Purchase savings is defined as the % difference between purchase cost and standard cost.

Let's say the summary dashboard lists a total savings of 5.3% across all suppliers for the period of October 2009. Now somebody looks at the detail report and says that they want to revise the purchase cost of a particular big-ticket-item in that period and see how it impacts the total savings.

I'm thinking of providing an input box for the end-user to type in a revised purchase cost just for that particular item. Once the user enters the price, the total savings should now be altered from 5.3% to, let's say 5.5%.

The problem that I'm wrestling with is -

How could I let the end user easily input a revised purchase cost, without selecting the item
How could I write a formula to calculate the 'what-if' total savings by taking into account the 'revised purchase cost' variable which is applicable only for one particular item.

Any quick thoughts or suggestions in implementing this?

Thanks in advance for your help.

topic What-If Analysis (Detail Level) in QlikView

What-If Analysis (Detail Level)