topic Calculated fields based on typed in data? in QlikView

Calculated fields based on typed in data?

Mon, 20 Apr 2015 06:24:27 GMT

Hi,

I'm wondering whether QV has any simulation functionalities like MS Excel, meaning

- I will have one cell where I type in data and other cells will recalculate. I can imagine having a field where I type In sales volume, another field where I type in unit margin and the automated calculation field would be absolute profit.

- Or, I change one parameter (e.g. sales volume) and all other parameters are automatically calculated - and the source data comes from the database

Is it possible to create such spreadsheets but seeding data from a larger number of fields?

Many thanks

Re: Calculated fields based on typed in data?

Anonymous — Mon, 20 Apr 2015 06:30:19 GMT

Hi,

You could use an input box. The data can be entered in the input box which would save the entered value in a variable and this variable can then be used in the calculation for other fields.

Regards,

Greeshma

Re: Calculated fields based on typed in data?

Anonymous — Mon, 20 Apr 2015 07:51:59 GMT

you can use Greeshma solution and also you can go for dynamic update if you want to store edited values to database as well for future use.

Thanks

BKC