Discussion board where members can get started with Qlik Sense.
Is it possible to create a pivot table like excel report with different headings and subheadings.
Below is the format.
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.
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
Dual( D3, AutoNumber(D3,'D3')) AS D3,
//Match( D3, 'Target','Actual')+1) AS D3,
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
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.