I'm working on a mini-project for inventory forecasting through the end of our fiscal year. I have a straight table that looks at on hand inventory, sales opportunities, and performs some calculations to output the forecasted inventory levels at the end of the current fiscal month. I am looking to add on additional columns that will carry my forecasting through the end of the year. I have a variable that gives me the current fiscal month.
I have an if statement that will output the remaining number of months beyond the current one. Now I am looking for a way to have my QlikView dashboard automatically generate the correct number of additional columns (based on remaining months in the year) and append them to my existing table.
From here, I will generate the variables and expressions I need with which to fill these columns.
In short, I am looking for a way to dynamically add on columns to an existing table and load them with dynamically generated expressions.
I would be extremely grateful for any advice or recommended reading.
