Is it possible to do this in Qlik sense?
I have this table:
| Product | Sales 2018 | Sales 2019 | Custom sales 2020 | Forecast 2021 | Forecast 2022 | Forecast 2023 | Target 2024 |
| A | 3 | 6 | user input | calculated | calculated | calculated | 25 |
| B | 6 | 8 | user input | calculated | calculated | calculated | 42 |
| ... | | | | | | | |
| Z | 2 | 5 | user input | calculated | calculated | calculated | 20 |
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.
