topic Re: Bank Balance Type Report in QlikView

Bank Balance Type Report

kangaroomac — Mon, 17 Dec 2012 10:30:50 GMT

Hi All,

I am trying to do a mimic of a "Bank Balance" type report. What I have is transactions happening with a transaction date. I have a cumulative amount adding each transaction.

There is a limit (in the demo set to 2000 in a variable). What I then do is see Balance (Limit - Cumulative). This all works if I have the TransactionDate going in Ascending order.

What I would like to do is have TransactionDate going in Descending order (i.e. Last Transaction showing first) with Balance having the lowest amount on top - with other words latest date showing latest balance.

I have attached a sample of what I mean.

Anyone have any ideas?

Thanks in advance.

Re: Bank Balance Type Report

Gysbert_Wassenaar — Mon, 17 Dec 2012 11:16:45 GMT

You can calculate the cumulative amount in the script. See attached qvw.

Re: Bank Balance Type Report

sujeetsingh — Mon, 17 Dec 2012 11:17:54 GMT

Please try to understand the assosiation of data ...

-when you short the TransactionID to decreasing...4,3,2,1.....

-then the expression will be throwing values related to the TransactionID how can ot chanse the data related to the expression got it....

It is all the data you are having for each transaction.

Re: Bank Balance Type Report

Mon, 17 Dec 2012 11:24:52 GMT

I guess you could do it like this.

This way, you can have the table sorted however you want...

Cheers

Martin

Re: Bank Balance Type Report

kangaroomac — Mon, 17 Dec 2012 11:39:55 GMT

Thanks guys,

Both worked, but for the real problem the expression option will work better.

Thanks again.