Using Input Fields with other calculations in Pivot/Straight Tables
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
Jan
Feb
Mar
Apr
May
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?
