Problem with accumulation in charts

[#1]

Hi All,

Attached is a qvw with my sample data.

As you see,ive used 'Full Accumulation' in my chart.

When i click on a particular month,the expression works fine.But,if i select both the months,

Data for 29th,30th and 31st shows the wrong value.

Since feb does not have 29th,30th and 31st, it is supposed to show the Jan value when i select both Jan and Feb in the listbox.

But,for below days it shows,

29th- Jan29th value(accumulated)+Feb29th value(Accumulated till 28th since 29th is not present for Feb)=5700(2900+2800)

30th-Jan30th value(accumulated)+Feb 30th value(Accumulated till 28th since 30th is not present for Feb)=5800(3000+2800)

31st-Jan31st value(accumulated)+Feb 31st value(Accumulated till 28th since 31st is not present for Feb)=5900(3100+2800)

Similarly for 31st.

The values i need are

29th-Jan29th value+Zero=2900

30th-Jan30th value+Zero=3000

31st-Jan31st value+Zero=3100

Please help.In a hurry!!!!

[jjordaan]

Hi Pavan,

I think it is working correctly.

When you select both the months every step is 200 (Because step is 100 per month) but for the days 29, 30 and 31 the steps are 100 beceause Feb does not have these days so the step should be 100 instead of 200.

Maybe I'm missing something

[#3]

Hi Jeroen,

Thanks a lot for your time.

The calculations happening in Qlikview are correct.

As you see from above image,for 29th-total value should be 2900+0=2900

But im getting 2900+2800=5700.

The 2800 should not be coming.(which is the value for Feb28)

This is the client requirement.

Thanks in advance:)

[Kushal_Chawda]

Basically you need to do selections on month.. when you selecting Jan you are getting the correct value..

Bydefault you are getting sum(28th day of jan) + sum(28 th day of Feb).

So for getting the correct values you need to do selection

[Kushal_Chawda]

Use distinct values for the same.

see the attached one