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 firstname.lastname@example.org
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.
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) .
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