Variables in Load Script like Excel

[atinternalaudit]

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.