Hello
I've been asked whether QV can create reports that are like spreadsheets. Can I produce tables in which almost every cell is calculated differently?
So as an example, see the attached spreadsheet. This shows actual figures for prior year, and actual figures for the first three months of this year. Then the remaining months are shown which contain forecasts. Each row is calculated differently and needs to be calculated in the application because the users need to be able to adjust the forecasts by changing some of the parameters in the formulas via input boxes or sliders.
I've had a play and tried to create this, but I don't think the standard pivot tables are flexible enough. So the answer might simply be "QlikView is not the right tool for this kind of report". But before I say that I wondered what your opinions were.
Thanks.
