topic Help with absolute sum in QlikView

Help with absolute sum

Wed, 11 Aug 2010 13:33:59 GMT

I have a table in qlikview that looks like

Needed Working Variance

Tellers 5 4 -0.25

Enquiries 3 1 -2

Sales 2 2 0

needed has =sum(needed)

working has =sum(working)

variance = (sum(working)-sum(needed))/sum(Working)

what I need so What I need is to get the absolute sum of the variance as in ABS(-0.25 + -2 + 0) = 2.25

How do I achieve this in qlikview

suniljain — Wed, 11 Aug 2010 13:38:48 GMT

convert each element of expression to absolute by fabs()

Wed, 11 Aug 2010 13:55:53 GMT

I've tried this and I'm still not getting any joy

Fabs((Sum(Working)-Sum(Needed))/Sum(Working))

Or — Wed, 11 Aug 2010 14:04:42 GMT

Try:

Sum(fabs((Working-Needed)/Working))

From a mathematical standpoint, you can't sum each part individually - if you do, you lose the variance.