Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qvqfqlik
Creator
Creator

Multiple headers

Need some help with pivot table with multiple headers.

Dates will be dynamic, eg: it can also have data for Aug-2018

I tried to follow https://community.qlik.com/t5/QlikView-Documents/multi-header-pivot-import-qvw/ta-p/1487398

But couldn't get it right.

DepartmentFeb-18Mar-18Apr-18May-18Jun-18Jul-18
 Sale1Sale2Sale1Sale2Sale1Sale2Sale1Sale2Sale1Sale2Sale1Sale2
Dept1109765711    
Dept2442101      

 

 

Required Output   
DepartmentDateSaleNo.of Sales
Dept1Feb-18Sale110
Dept1Mar-18Sale17
Dept1Apr-18Sale15
Dept1May-18Sale11
Dept1Jun-18Sale1 
Dept1Jul-18Sale1 
Dept1Feb-18Sale29
Dept1Mar-18Sale26
Dept1Apr-18Sale27
Dept1May-18Sale21
Dept1Jun-18Sale2 
Dept1Jul-18Sale2 
Dept2Feb-18Sale14
Dept2Mar-18Sale12
Dept2Apr-18Sale10
Dept2May-18Sale1 
Dept2Jun-18Sale1 
Dept2Jul-18Sale1 
Dept2Feb-18Sale24
Dept2Mar-18Sale24
Dept2Apr-18Sale24
Dept2May-18Sale2 
Dept2Jun-18Sale2 
Dept2Jul-18Sale2 

 

4 Replies
StarinieriG
Partner - Specialist
Partner - Specialist

qvqfqlik
Creator
Creator
Author

Thankyou,

Iam trying to represent this in a chart something like in this picture.

clipboard_image_0.png

Iam unable to show the Dept1, Dept2, Dept3, Dept4 data in the stacked bars.

Iam only able to show Sale1, Sale2 and Number of sales. Need to show Dept1, Dept2, Dept, Dept4 aswell in the stacked bars.

clipboard_image_1.png

qvqfqlik
Creator
Creator
Author

I created a drill down dimension (Sale->Department) and the below is what Iam able to show. But unable to show "Sale1", "Sale2" categories is missing in the chart

clipboard_image_0.png

Need to show something like below

clipboard_image_2.png

sunny_talwar

You might have 2 dimensions in your chart, right? Can you try adding a third dimension (dummy dimension) which would be calculated dimension with value 1.