topic Calculating division in Set Analysis in QlikView

Calculating division in Set Analysis

Thu, 25 Feb 2010 13:39:02 GMT

Hopefully this will be a real easy one for somebody...

I am trying to calculate % variance using the following formulas;

(Actual - Budget) / Budget

1- (Actual/Budget)

e.g.

Actual	Budget
282751	287200	1.55%

However when i build these as expressions in QV i do not get the result i was expecting.

Here is my code

Would appreciate somebody having a look!

Cheers

Rob

Calculating division in Set Analysis

Thu, 25 Feb 2010 13:41:06 GMT

Sorry here is my code;

=1-(sum({$<Costcategory={Invoiced, [EYP], [Milk Grants], [Other Income]}>} Act)/2

sum({$<Costcategory={Invoiced, [EYP], [Milk Grants], [Other Income]}>} Bud)/2)

Calculating division in Set Analysis

Miguel_Angel_Baeyens — Thu, 25 Feb 2010 13:42:32 GMT

Hello Rob,

First, unfortunately your code is not posted. Anyway, you can create a new expression, having already both Actual and Budgest as labels for two expressions like

=([Actual] - [Budget]) / [Budget]

This should work.