topic Re: calculating balances in QlikView

calculating balances

Sat, 28 Mar 2015 19:00:30 GMT

I wanna bring drill down into my table and

Note: closing balance of the previous year (Dec) should be moved to opening of the next year(Jan).

Find attached.

Regards

Re: calculating balances

sunny_talwar — Sat, 28 Mar 2015 19:15:26 GMT

Try the following expression:

If(if(RowNo(TOTAL)=1,0, Above(TOTAL [Closing balance])) = 0, sum([Opening balance]), if(RowNo(TOTAL)=1,0, Above(TOTAL [Closing balance])))

Also Attaching your document.

HTH

Best,

Sunny

Re: calculating balances

sunny_talwar — Sat, 28 Mar 2015 19:17:31 GMT

It may not be doing what you wanted, but see if this is what your intention was.

Best,

Sunny

Re: calculating balances

Sat, 28 Mar 2015 22:07:14 GMT

Hello Sunindia,

This almost wat i wanted but the carryover of closing bal (Dec) to (Jan) from year to year isnt working also when i click on a particular month the opening bal. changes from the value that was there before i clicked on it.

Re: calculating balances

Sat, 28 Mar 2015 22:11:00 GMT

Also i believe above wont give accurate answer because. its the previous month balance which is month - 1

Re: calculating balances

sunny_talwar — Sat, 28 Mar 2015 22:29:26 GMT

Not sure what you mean, Can you put together a table which shows the output you are expecting for 2014 and one table with the expected for 2015. May be then I will be help.

Best,

Sunny

Re: calculating balances

Sat, 28 Mar 2015 22:57:32 GMT

This is exactly what i wanna see on my table but it should have drill down you see how the values are carried to the next month and next year. this what i want to achieve but in drill down what do i do

Re: calculating balances

MK_QSL — Sun, 29 Mar 2015 07:53:49 GMT

Table1:

Load * From YourQVD.qvd;

NoConcatenate

Table2:

Load

If(RowNo() = 1, 0, Previous([Closing balance])) as [Opening balance]

Blah,

Blah

Resident Table1

Order By Year, Month;

Drop Table Table1;

Note : May be you need to format your month as Date#(Month,'MMM') as Month

Re: calculating balances

Sun, 29 Mar 2015 15:53:17 GMT

Hello Manish,

I tried this but it didn't pass Closing balance value of a particular month to the month opening balance.

Re: calculating balances

Sun, 29 Mar 2015 16:01:50 GMT

Find attached what I got

Re: calculating balances

MK_QSL — Sun, 29 Mar 2015 17:05:03 GMT

Unable to open the attachment.. Kindly reload...

Re: calculating balances

Sun, 29 Mar 2015 20:58:56 GMT

Ok , Find attached