Variance Field in Qlik

[#1]

I need to create a "Variance" column in qlikview:

                     2013       2014      Variance
Measure 1    100          110        10%
Measure 2    105          100        -4.8%
...
Can this be done in Qlikview with just one "Calculated dimension" column that says something like:

[Value for Column2]/[Value for Column 1] - 1
So that it works for any new measures I add in the table and regardless of what the column 1 and column 2 are?

[shaktisinghchau · Accepted solution]

You can do this with the Column() function.

Column(2) / Column(1)

The number refers to the Expression column -- first Expression is #1, etc. Dimension columns are not counted.

An alternative that is insensitive to column position, you can use column labels in the expression. Assume expressions with labels of "Sales" & "Margin". The variance expression can be written as:

[Margin] / [Sales]