Discussion Board for collaboration on QlikView Scripting.
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.
Thanks for your input.
I got the answer outside the forum and did this in a different way.