topic Re: VARIENCE in QlikView

VARIENCE

sagaraperera — Fri, 27 Mar 2015 08:48:41 GMT

I want to new expression in variance but it is get the budget - actual how is create a expression

awhitfield — Fri, 27 Mar 2015 13:01:22 GMT

Hi Sagara,

you need to supply more information about your data.

Andy

jonathandienst — Fri, 27 Mar 2015 13:18:20 GMT

As an example:

In a table with Month (or date) as dimension, and these expressions:

Col1: Sales = Sum(Sales)

Col2: Budget = Sum(Budget)

Variance: Column(2) - Column(1)

HTH

Jonathan