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?
