Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
qvqfqlik
Contributor

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
Partner
Partner

Re: Multiple headers

qvqfqlik
Contributor

Re: Multiple headers

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
Contributor

Re: Multiple headers

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

Re: Multiple headers

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.