topic Re: Multiple headers in App Development

Multiple headers

qvqfqlik — Tue, 17 Sep 2019 19:49:18 GMT

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.

Department

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

	Sale1	Sale2	Sale1	Sale2	Sale1	Sale2	Sale1	Sale2	Sale1	Sale2	Sale1	Sale2
Dept1	10	9	7	6	5	7	1	1
Dept2	4	4	2	1	0	1

Required Output
Department	Date	Sale	No.of Sales
Dept1	Feb-18	Sale1	10
Dept1	Mar-18	Sale1	7
Dept1	Apr-18	Sale1	5
Dept1	May-18	Sale1	1
Dept1	Jun-18	Sale1
Dept1	Jul-18	Sale1
Dept1	Feb-18	Sale2	9
Dept1	Mar-18	Sale2	6
Dept1	Apr-18	Sale2	7
Dept1	May-18	Sale2	1
Dept1	Jun-18	Sale2
Dept1	Jul-18	Sale2
Dept2	Feb-18	Sale1	4
Dept2	Mar-18	Sale1	2
Dept2	Apr-18	Sale1	0
Dept2	May-18	Sale1
Dept2	Jun-18	Sale1
Dept2	Jul-18	Sale1
Dept2	Feb-18	Sale2	4
Dept2	Mar-18	Sale2	4
Dept2	Apr-18	Sale2	4
Dept2	May-18	Sale2
Dept2	Jun-18	Sale2
Dept2	Jul-18	Sale2

Re: Multiple headers

StarinieriG — Wed, 18 Sep 2019 14:46:10 GMT

Hi,

try to see file attached

I have followed these steps: https://community.qlik.com/t5/New-to-QlikView/Inputting-an-excel-table-with-multiple-headers/td-p/1537852

Re: Multiple headers

qvqfqlik — Wed, 18 Sep 2019 16:48:06 GMT

Thankyou,

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

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.

Re: Multiple headers

qvqfqlik — Wed, 18 Sep 2019 17:32:29 GMT

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

Need to show something like below

Re: Multiple headers

sunny_talwar — Thu, 19 Sep 2019 13:23:24 GMT

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.