topic Problem with the SUM expression in QlikView

Problem with the SUM expression

Wed, 03 Jun 2009 04:24:43 GMT

Hello All,

Let's consider following table:

MONTH_CODE DATE AMOUNT

2009/01/01 2009-01-25 200

2009/01/01 2009-01-31 250

2009/01/02 2009-02-14 300

2009/01/02 2009-02-28 350

2009/01/03 2009-03-31 400

2009/02/04 2009-04-30 500

Now, I would like to ask you to help me to evaluate an expression that for the selected MONTH_CODE calculates the sum of the AMOUNT field for all previous records.

For the MONTH_CODE:

- 2009/01/01 -> 450

- 2009/01/03 -> 1500, etc.

Probably it is really easy but I can't figure out the proper solution. [8o|]

Thanks in advance for your help.

Kind regards,

JTPro

Problem with the SUM expression

johnw — Wed, 03 Jun 2009 05:42:49 GMT

Well, it depends on WHERE you want to do this. If this is in a chart, for instance, using sum(AMOUNT) and selecting Full Accumulation may be all you need. If that's not it, let us know a few more details so that we can help you further.

Problem with the SUM expression

Wed, 03 Jun 2009 13:56:00 GMT

Hi,

I just need to evaluate expression without putting it into chart.

My intention is to allow user to select appropriate month code and as a result give him/her an accumulation sum from the beginning of the year.

I hope my explanation is more clear right now.

Kind regards,

JTPro

Problem with the SUM expression

Wed, 03 Jun 2009 17:39:45 GMT

Please, help me to figure out the right expression. I know that there must be something tricky 🙂

Kind regards,

JTPro

Problem with the SUM expression

Wed, 03 Jun 2009 18:05:07 GMT

hmm.. in my experience, I used a pivot table and accumulated the totals. This provides the user full visibility of all periods though. To cumulate, you must use either the ABOVE function or BEFORE functions.

Other than that, I cant help you any further with that.

Mike

Problem with the SUM expression

Wed, 03 Jun 2009 18:16:49 GMT

Hi,

Check the attached application.

Hope that should solve your purpose

- Sridhar