Using Input Fields with other calculations in Pivot/Straight Tables

Tue, 23 Jun 2015 10:02:10 GMT

Hi All,

I'm a beginner at Qlikview and I'm having an issue with input fields. I have set up a table like the one below showing different part numbers and the units we forecast to sell in different months.

Part Numbers	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Part 1	1	2	3	4	5	6	7
Part 2	2	3	4	5	6	7	8
Part 3	1	3	4	5	6	8	8
Part 4	7	5	4	6	8	9	9

The idea is to Input the units we forecast to sell in the future months and the expression I've used is as follow : 'Inputsum(InputUnits)'. Now the issue is, for the previous months (since we have the actual units sold and that data is in the QVD loaded in my dashboard), I want to bring those units for the months actualized. Is there a way in which I can use the Input Fields for the future months and other expressions for previous months bringing the actual sales in the same table? Can I use SET ANALYSIS or is there a better way to do that?

Thanks

Zarar

topic Using Input Fields with other calculations in Pivot/Straight Tables in QlikView

Using Input Fields with other calculations in Pivot/Straight Tables