topic Re: Month wise opening balance calculation in QlikView

Month wise opening balance calculation

Anonymous — Wed, 25 May 2011 12:57:10 GMT

Hi Friends,

From a transaction file I want to calculate month wise opening balance.I have attached a xl file for datasource and output formal.

regards,

chandan

Tue, 07 Jun 2011 05:39:23 GMT

Hi Chandan,

Did you get answer for your above Query?

If you got answer then please forward the same logice to me, Even i also need solution for above Query.

Regards,

Antony.

Tue, 07 Jun 2011 06:15:13 GMT

Hi,

is that you looking for?Reply me if you have any concern

-Jai

Tue, 07 Jun 2011 06:32:51 GMT

Hi JP,

Thanks for your reply.

This is not my requirment , Can you please check my attachment.

Regards,

Antony.

qliksus — Tue, 07 Jun 2011 06:46:46 GMT

Try this

if( rowno()=1, sum(x) ,

above(column(1)+column(2)) )

Tue, 07 Jun 2011 07:11:49 GMT

Hi,

Find the attachment.Let me know any if u have concerns

-Jai

Tue, 07 Jun 2011 11:52:19 GMT

Hi ,

Please Find the Attached Application.