Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

chandan_chakrab
New Contributor

Month wise opening balance calculation

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

Tags (1)
6 Replies
Not applicable

Month wise opening balance calculation

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.

Not applicable

Re: Month wise opening balance calculation

Hi,

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

-Jai

Not applicable

Re: Month wise opening balance calculation

Hi JP,

      Thanks for your reply.

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

Regards,

Antony.

qliksus
Valued Contributor

Re: Month wise opening balance calculation

Try this 

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

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

Not applicable

Re: Month wise opening balance calculation

Hi,

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

-Jai

Not applicable

Re: Month wise opening balance calculation

Hi ,

Please Find the Attached Application.

Community Browser