showing different avg for table and KPI

[Suraj_Kendre]

Hello,

I have data to calulate performance.

if(sum(Aggr (RangeSum(Above(Sum(D_Actual_Nos),0,RowNo())),D_Plan_Item,D_End_Date))/sum(Aggr (RangeSum(Above(Sum(D_Plan_QTY),0,RowNo())),D_Plan_Item,D_End_Date))>1,1,
sum(Aggr (RangeSum(Above(Sum(D_Actual_Nos),0,RowNo())),D_Plan_Item,D_End_Date))/sum(Aggr (RangeSum(Above(Sum(D_Plan_QTY),0,RowNo())),D_Plan_Item,D_End_Date)))*100 

above expression woking in staight table but when i do apply in gauge or in KPI it showing diff of avg

refer below snap.

any suggestion please 

[sandeep-singh]

Auto means calculating the total by evaluating the expression's overall data. Sum means to sum up the rows in the chart. There can be differences depending on your data model and the dimensions used. For example, Auto will never double-count. The sum can double count.

Please read the below article on what total qualifiers do

https://community.qlik.com/t5/Design/What-does-the-TOTAL-qualifier-do/ba-p/1472990