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?
Thanks
Zarar