1 Reply Latest reply: Oct 8, 2018 10:17 PM by An Pham RSS

    Qlik Sense: Mismatch for table column value and KPI value

    raja Indianprakaash

      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)

       

      KPI.png

       

      Attached the qvf file for reference and help.