Hey, guys. I need your help. Please help me with my problem.
I have a predictive model in Excel with 7 variables ( x,y,c,d,e,f,h).
I have to load this file to Qlik Sense.
I want define variables ( x,y,c,d,e,f,h), but I can't imagine how to copy this formulas.
So, I have default value for 7 variables, but user want to change them. So, I use qsVariable extensions.
I have columns
Row number | Year | X | Column2 | Column3 | 1 | 2017 | X | X/1000 * Y | Column 2 * F | 2 | 2018 | X | Column3(1 row number) * Y | Column 2 * F | 3 | 2019 | X | Column3(2 row number) * Y | Column 2 * F | 4 | 2020 | X | Column3(3row number) * Y | Column 2 * F | 5 | 2021 | X | ... | ... | 6 | 2022 | X | ... | ... |
| | | |
And I have to create line chart with Year dimension and Column3 measure. I understand how create a table, but i can't understand how create line char.