Pivot Table design

[remyasujith]

Hi,

Is it possible to create a pivot table like excel report with different headings and subheadings. 

Below is the format.

[petter]

Yes it is:

I have attached the sample application where the screenshot has been taken from...

[remyasujith]

Hi Petter,

Thanks for your reply, am new to qlik so little confused on the script. I changed the inline like this, but am stuck at expression. Please help.

LOAD
Dual( D1, AutoNumber(D1,'D1')) AS D1,
//Match( D1, 'MTD-Sales','Daily Average','Actual Sales Ltrs') ) AS D1, // Dual is needed for getting the headers sorted right
D2,
Dual( D3, AutoNumber(D3,'D3')) AS D3,
//Match( D3, 'Target','Actual')+1) AS D3,
D4,
D5
INLINE [
D1, D2, D3, D4, D5
MTD-Sales, , Actual Gross Sales (Ltrs)
MTD-Sales, , Wastage (Ltrs)
MTD-Sales, , Wastage %
Daily Average, , Target
Daily Average, , Actual
Actual Sales Ltrs, Channel, KEY OUTLETS
Actual Sales Ltrs, Channel, SUPER MARKETS
Actual Sales Ltrs, Channel, GROCERIES
Channel Wise Wastage %,KEY OUTLETS,Target
Channel Wise Wastage %,KEY OUTLETS,Actual
Channel Wise Wastage %,SUPER MARKET,Target
Channel Wise Wastage %,SUPER MARKET,Actual
Channel Wise Wastage %,GROCERIES,Target
Channel Wise Wastage %,GROCERIES,Actual
MTD, ,CarryOver %
MTD, ,Avg Call Rate
MTD, ,Distribution Achievement% Groceries
];

[petter · Accepted solution]

This is a better structured way of doing it than the one I suggested yesterday:

[remyasujith]

Hi Petter,

Am facing an issue in actual and target. As you mentioned 4 and 5 are for Target and Actual, but from 9-14 same expression is working. 

In the screenshot you can see after 8 it is again 4 and 5 repeating. 

Even it is target and actual my expression differs. Please help.

[remyasujith]

Thanks Petter. 

I changed the name Target to Target K/A and it works.