2 Replies Latest reply: Apr 19, 2017 10:12 AM by Shubham Sharma RSS

    Add a calculated column into Qlikview SQL select statement

    Shubham Sharma

      Hello All


      I am new to qlikview and in the learning phase.


      I have connected to the OLE DB and was able to fetch the data using the sql query.


      OLEDB CONNECT TO Server_Name


      SQL SELECT SysContractID,



          "Wholesaler Code"

      FROM "discount_and_promotion".dbo."tbl_Contract_Details";

      Store summary_tbl_contract_details into summary_tbl_contract_details.qvd (qvd);



      What I want is a calculated column.


      I want to sum up the "Target_Qty" grouped by SysContractID,"Wholesaler Code" & TimePeriod.


      Can someone help me with the code.