How to get the Net MoM?

[Anonymous]

Hi

I have a quick question.

Im creating a QV report to check finances, and I cant get the Net MoM right. Here I left an example

Outs are all the payments or outcomes done during a month. SUM(Outs)

Ins are all the incomes I got during a month. SUM(Ins)

Net M, is the Net of that Month. SUM(Ins)-SUM(Outs)

And this is the problem. Net Acum. Here I need to take last month Net Acum and add the Net M. Ive tryed this but doesnt work.

+above([Net Acum])+sum(Ins)-sum(Outs).

Could you help me?

[maxgro · Accepted solution]

what about using the same expression as Net M and flagging "Full Accumulation"?

[Anonymous]

Wow, I never though about it, and was so easy. Its embarrassing how little I know about this amazing tool. Thanks Massimo!

Any recommendation regarding where I can keep learning?

[#4]

Try

Expression labeld NET Acum

RangeSum(above(Sum([Net M]), 0,RowNo(TOTAL))) 

[#5]

And in the case you have more than one dimension, and still want the same result, then just add the TOTAL keyword inside the Above function like this:

RangeSum(Above(TOTAL Sum([Net M]), 0,RowNo(TOTAL)))

[maxgro]

there are many interesting resources

http://community.qlik.com/message/622695#622695 look at Jonathan Poole answer

and also it seems that some books (Qlikview for Developers, ....) are on sale now