Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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/15...
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.
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
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.