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,

          "Target_Qty",

          TimePeriod,

          "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.