Dynamic Column Generation

Tue, 28 Jul 2015 19:56:59 GMT

Hi Everyone,

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.

Thanks,

Daniel

topic Dynamic Column Generation in QlikView

Dynamic Column Generation