topic Re: Same expression giving different values in QlikView

Same expression giving different values

Mon, 13 Apr 2015 11:23:57 GMT

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 — Mon, 13 Apr 2015 12:11:28 GMT

Please post a qlikview document that demonstrates the problem

sunny_talwar — Mon, 13 Apr 2015 12:12:35 GMT

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