This content has been marked as final. Show 2 replies
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,
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.