topic Re: How to get the Net MoM? in QlikView

How to get the Net MoM?

Anonymous — Sun, 28 Dec 2014 19:17:26 GMT

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?

Re: How to get the Net MoM?

maxgro — Sun, 28 Dec 2014 20:12:08 GMT

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

Re: How to get the Net MoM?

Anonymous — Sun, 28 Dec 2014 23:23:19 GMT

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?

Re: How to get the Net MoM?

Sun, 28 Dec 2014 23:33:40 GMT

Try

Expression labeld NET Acum

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

Re: How to get the Net MoM?

Sun, 28 Dec 2014 23:47:08 GMT

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)))

Re: How to get the Net MoM?

maxgro — Mon, 29 Dec 2014 08:13:46 GMT

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