Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
See Accumulations
HIC
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.
Would you be able to provide just a few lines of data to test?