topic AW:Monthly differences in QlikView

Monthly differences

Fri, 28 Jan 2011 10:47:31 GMT

Hello QVer,
I have an expression in a straight table like "(sum(A)-sum(B))/sum(B)" which gives results as
2,88%
3,95%
2,36%

Now I want to have as result (as monthly differences)
-
1,07%
-1,59%
and so on.

I tried <before>, <peek> etc. Nothing helped.

Can anybody please point me to the right calculation. Thanks in advance.
Best regards dj_skbs

Fri, 28 Jan 2011 11:13:45 GMT

Hello dj_skbs,

let me call your expression in your straight table "percentage". Then try an expression like this:

above([percentage])-[percentage]

Regards,

Roland

Fri, 28 Jan 2011 11:36:08 GMT

Hello Roland,

That's it. I failed to see <above>. Thank You. dj_skbs