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.
This is a better structured way of doing it than the one I suggested yesterday:
View solution in original post
Yes it is:
I have attached the sample application where the screenshot has been taken from...
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.
LOADDual( 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 rightD2,Dual( D3, AutoNumber(D3,'D3')) AS D3,//Match( D3, 'Target','Actual')+1) AS D3,D4,D5INLINE [D1, D2, D3, D4, D5MTD-Sales, , Actual Gross Sales (Ltrs)MTD-Sales, , Wastage (Ltrs)MTD-Sales, , Wastage %Daily Average, , TargetDaily Average, , ActualActual Sales Ltrs, Channel, KEY OUTLETSActual Sales Ltrs, Channel, SUPER MARKETSActual Sales Ltrs, Channel, GROCERIESChannel Wise Wastage %,KEY OUTLETS,TargetChannel Wise Wastage %,KEY OUTLETS,ActualChannel Wise Wastage %,SUPER MARKET,TargetChannel Wise Wastage %,SUPER MARKET,ActualChannel Wise Wastage %,GROCERIES,TargetChannel Wise Wastage %,GROCERIES,ActualMTD, ,CarryOver %MTD, ,Avg Call RateMTD, ,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.
I changed the name Target to Target K/A and it works.