Discussion Board for collaboration related to QlikView App Development.
i have an input table like this.
i need to calculate the columns Offset and total. the logic for which are as follows
I need to create a dynamic logic for this, as data for more years may come.
They can be calculated in script or via expressions.
Please suggest. thanks in advance.
Please check the attached qvw for an example of how to calcuate values in script.
Hope it helps.