topic Accumulation problem in QlikView

Accumulation problem

michael_maeuser — Thu, 15 Dec 2011 14:00:21 GMT

Hello, I want to do an accumulation in an bar chart(sorted descending, so I can´t use the full accumulation because it must start accumulation at the earliest date). I think it´s somehow makable with rangesum. But not sure. Secondly it should accumulate from the earliest date while showing only the current week in the chart.can somebody help me out? Thanks in advance. attached is a sample qvw

Re: Accumulation problem

brenner_martina — Thu, 15 Dec 2011 14:21:44 GMT

Hi, Micheal,

what do you really need? See your attached example, Tab Martina

Greetings from Munich

Martina

EVACO GmbH

Accumulation problem

michael_maeuser — Thu, 15 Dec 2011 14:41:53 GMT

in your version, if i add the fields month and year and select the current month and year. it doesn´t show me all 31 days because there have been no changes. and furthermore if current month and year is selected, it won´t show the correct liquidity because it only accumulates this month and not from 2007

Accumulation problem

brenner_martina — Thu, 15 Dec 2011 15:59:01 GMT

Hi, Michael,

at first you have to fulfill all dates, to get a fully month shown. In the Developer seminar you have the chapter 9 Täglicher Saldo! That would help you.

Grüße aus München

Martina

EVACO GmbH