topic Re: Variance Field in Qlik in QlikView

Variance Field in Qlik

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Variance Field in Qlik

shaktisinghchau — Fri, 23 Dec 2016 04:41:28 GMT

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]