Same expression giving different values

[#1]

Hello Everybody,

I am using the below expression in Bar chart as well as in Straight table. And filtering the data based on quarter of a year.

=round(sum({$<Type_Data= {'BookedActuals'},Initiatives=,Lead= , WeightedUnweighted= >}RevPreAmount)/1000000,'0.01')

in Bar chart am getting the value Month wise jan, feb and Mar but in Straight table I am getting the Max of the quarter data i.e. Mar data.

Ideally it should show the same data in both the chart means In staright table the result should be 21+94+129=244 where as it's showing 129.

Please find attached Image

Thanks & Regards

Ashish

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem

[sunny_talwar]

It is difficult to pinpoint the exact issue without looking at the qvw file. Would you be able to post a sample qvw to show your problem?

Best,

Sunny