Accumulation in expression

[#1]

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

[sunny_talwar]

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?

[hic]

See Accumulations

HIC

[#4]

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.

[sunny_talwar]

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