Are you using a query for pivot table ? Which Database are you using ?

Yes, Pawan. I'm using a query (load script) in Qlikview. SQL Server 2016 is the database.

Please provide me the query. Will modify that for you to the required result. Also add SQL Server as a Topic for future reads.

ODBC CONNECT TO TEST_SQL_SERVER;
CUR_QTR:
LOAD
      NAME,
      DATE1,
      COMPANY,
      AMT,
      LEFT(DATE1,4)             AS YR,
         RIGHT(DATE1,2)             AS MTH
;
SELECT *
FROM CUR_QTR;

JOIN(CUR_QTR)
LOAD
NAME,
      DATE1,
      COMPANY,
      AMT,
      LEFT(DATE1,4)             AS YR,
         RIGHT(DATE1,2)             AS MTH


FROM
[C:\TEST.xlsx]
(ooxml, embedded labels, table is Sheet1);

This is the query from Qlikview. CUR_QTR is the table from SQL server that has data for 201703 only. For prior period the data is loaded from Excel file. While creating the pivot table in QLikview, this script is used to create dimensions n measures. Measure is the sum(Amt).

Are you doing pivot in SQL server or in QlikView?

Doing Pivot in Qlikview - within Pivot table (chart).

try Like this... (Never did that in UI though)

DIFF1 : {201703} - {201612}

I tried that earlier. That didn't work. It also creates column under each year month.

Question abandoned.
Provided tested solution.