topic Accumulation in expression in QlikView

Accumulation in expression

Wed, 24 Feb 2016 07:19:07 GMT

Hi All,

I am new to qlikview and created a chart for actual and budget.

I have tried to sum up and display accumulated value using full accumulation and it displaying as per expected, but I don't want to show accumulated value, if there is no data value available. As per screen shot, data is only available for 4th and 5th, so it should accumulate till 5th and from 6th it should be blank.

Can anyone please help me in providing expression to achieve this.

Please explain in detail, as i am very new to qlikview.

Regards

Ankathi

Re: Accumulation in expression

sunny_talwar — Wed, 24 Feb 2016 09:51:50 GMT

In that case, I would recommend Accumulating using an RangeSum(Above()) expression rather than using qlikview's inbuilt functionality because it offers more flexibility. Would you be able to provide a sample where we can show you how this can be done?

Re: Accumulation in expression

hic — Wed, 24 Feb 2016 09:58:57 GMT

See Accumulations

HIC

Re: Accumulation in expression

Thu, 25 Feb 2016 01:29:31 GMT

Hi Sunny Thanks for your response,

I have tried using Range Sum, but still doesn't work.

I got Calday broken down in my script by day, month and year and got Actual's data coming daily.

Day as dimension and Actual and budget as expressions.

For example,

I will have actual data for today and budget calculated for each year.

I have used round(sum(Actual)) and Full accumulation and if use No accumulation, it breaks values as per day and leave's days, if there is no date.

Re: Accumulation in expression

sunny_talwar — Thu, 25 Feb 2016 09:35:00 GMT

Would you be able to provide just a few lines of data to test?