topic Conditional summing in QlikView

Conditional summing

m4u — Sun, 27 Dec 2009 22:11:13 GMT

I am trying to do something equal to a sql subquery in a line chart

Assuming I have table with two fields - date and transaction_sum (can be positive or negative)

I would like to display a chart showing the history of the open debt at each date. The open debt is the sum of all transaction sums UP TO the point of that date. What expression can I use for this case (during presentation only)

Conditional summing

amien — Mon, 28 Dec 2009 01:25:14 GMT

you cant work with:

SUM(IF(DATE < transaction_sum,DEBT))

Conditional summing

Mon, 28 Dec 2009 01:30:54 GMT

Why not

Sum( If ( date < dimDate , transaction_sum ))

where dimDate is your dimension, it could be given date depending of what you want to represent.

If you want to see each date on the graph, best is to create a calendar (see example on the community).

regards

Conditional summing

m4u — Mon, 28 Dec 2009 15:58:03 GMT

This is exactly the point when I get stuck:

Sum( If ( date < dimDate , transaction_sum ))

now, date is the date field in the condition, but what is dimDate? How do I refer to the dimension variable? In my case, date is also the dimension itself..

Conditional summing

Mon, 28 Dec 2009 16:25:35 GMT

You can define twice your date in the script

Date,

Date as dimDate ,

...

I have another idea for your problem

use Date as dimension,

use sum(transaction_sum) as expression

and click on "Full accumulation" in the expression menu.

Please Give feed back

Conditional summing

m4u — Wed, 30 Dec 2009 00:13:58 GMT

Thanks

I've played with both methods and got what I need