Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Pivot Table design

Hi,

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

Below is the format.

example.png

Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

 

2019-07-08 15_41_30-Qlik Sense Desktop.png

2019-07-08 15_42_25-Qlik Sense Desktop.png

2019-07-08 15_45_49-__ Pivot Table Design - My new sheet _ Sheets - Qlik Sense.png

View solution in original post

5 Replies
Highlighted
MVP
MVP

Yes it is:

Annotation 2019-07-07 152425.jpg

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

 

Highlighted
Contributor III
Contributor III

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
];

Highlighted
MVP
MVP

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

 

2019-07-08 15_41_30-Qlik Sense Desktop.png

2019-07-08 15_42_25-Qlik Sense Desktop.png

2019-07-08 15_45_49-__ Pivot Table Design - My new sheet _ Sheets - Qlik Sense.png

View solution in original post

Highlighted
Contributor III
Contributor III

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.

Contributor III
Contributor III

Thanks Petter. 

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