In the sheet I want the user, after filtering only one product, that will be able to input a cutom value for "custom sales 2020" and then Qlik should shows 3 possible scenarios (3 different way to calculate forecast 2021, 2022 and 2023, based on sales 2018, sales 2019 and target 2024).
In another table I want the results:
Method
Product
Sales 2018
Sales 2019
Custom sales 2020
Forecast 2021
Forecast 2022
Forecast 2023
Target 2024
1
A
3
6
8
10
12
14
24
2
A
3
6
8
12
16
20
24
3
A
3
6
8
16
32
64
24
And I want a line chart with 3 lines (1 for each method) with values from 2018 to 2024. For this I think a crosstab is better, but I don't know how to manage the previous steps.
