Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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...
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.