topic Inputsum, applying value or formula in QlikView

Inputsum, applying value or formula

Mon, 18 May 2015 09:59:52 GMT

Hi,

In Budgeting process I have developed inputfield (inputsum) Pivot Table object.

Everything is working fine, but I've received a Request from Controlling to develop another Functionality.

They want to have three input fields (Growth, Growth in %, Absolute Growth).

The Problem is, those three fields must be calculated either on inputted Value in one field or be calculated based on value inputted in one of two other fields. And vice versa.

Exampl in Steps

Do you have any Ideas how to do that?

It has to determine what has been changed in all three fields on cell level and then apply value or formula to calculate new value.

Must be possible to do that multiple times.

Should I use VBScript or JScript?

I will appreciate any suggestion or lead.

Thank you in advance.

Best

Tom

Re: Inputsum, applying value or formula

dcheung3388 — Sat, 15 Aug 2015 06:01:40 GMT

Hi Tom,

Did you have any luck with this?

I'm trying to do something similar and it is pulling my hair out...

Any ideas or suggestions would be a great help.

If you have any sample that you could share with me to help me better understand, that would be great too.

my email is dcheung9988@outlook.com

Thanks

David

Re: Inputsum, applying value or formula

marcus_sommer — Sat, 15 Aug 2015 09:12:48 GMT

It's quite difficult to build a complex forecasting model within qlikview with inputfields and/or variables. In such cases you should consider to use an extension like SQL Writeback from QlikView extension object. or using a third party tools like KliqPlan (Planning Suite).

If I would try it to solve directly with qv functionalities I would probably create each expression twice - one with the inputsum and one with calculations regarding the other inputfields - and switching between them per visibility-conditions controlled per (calculated) variable(s) or a button-control.

- Marcus

Re: Inputsum, applying value or formula

Mon, 17 Aug 2015 08:57:41 GMT

Hi David,

Sorry for delayed answer.

Yes, I've found the way to solve this request from my Clients.

It's combination between Qlikview and Excel and Codes in VB Script.

There are lot of restrictions using inputfield, but at the end you can manage it.

Are you using Server (Access Point) or just Desktop version?

Can you send a short example and I will try to give you a hint how to solve it.

I've learned a lot about Inputfield and Inputsum, and I'm preparing the Cheat Sheet for it (I hope soon) .

Best

Tom

Re: Inputsum, applying value or formula

Joaquin_Lazaro — Fri, 25 Sep 2015 10:57:10 GMT

Hi tlepcin2805

I need to create a straight table with two cyclic groups as dimensions and a InputField(Budget) as a expresión and a second expression Sum(Sales)

The first group is Company/Salesmans

The second group is Year/Month

The granularity of Sales table is date, the granularity of Budget it would be month or years

I have no idea about how to do this, can you share some example ?

Thank you very much

Joaquín