Qlik Sense: Mismatch for table column value and KPI value

[raja_indianprak]

Hi,

I have a Quantity table with Job no,Quantity and Shipment column. I am trying to publish the table column in KPI but the result is getting mismatched.

Function used:

1. Order Qty table column = sum(TOTAL_ORDER_QTY)/count(TOTAL_ORDER_QTY)

2. Order Qty KPI = sum(TOTAL_ORDER_QTY)/count(TOTAL_ORDER_QTY)

Attached the qvf file for reference and help.

[kenphamvn]

Hi

in KPI you need calculation by each JOBNO before Sum all

please edit you KPI expression like

sum(aggr(Sum(TOTAL_ORDER_QTY)/count(TOTAL_ORDER_QTY),JOBNO))

Regards

An Pham