How to achieve 2 dimensional bar stacked bar chart in QlikView?

[#1]

Hi,

Is there any way to have two dimensions to achieve a stacked bar graph. In Tableau, this functionality is super easy and its just a matter of drag and drop. But I would like to know if is there any way to achieve this. I heard multi dimensions isn't possible in QlikView.

Abhijit

[#2]

Hi Vineeth,

Thank you for your reply. This would definitely help me out in defining all the PMTs. But how would we achieve this in order to filter the PMT groups?

Here I have 5 PMT groups and I need to show it on the graph according to the filter selection. If I am selecting 3 PMT groups in filter then it should show 3 PMTs in the grid. How will we achieve the labels in order to have ad-hoc PMT filtering?

Abhijit

[vinieme12]

There are two ways to calculate charts

Option1) Modify the Set Expression for PMT level 1 and add and asterisk(*) before the equalto sign

Example = sum({<[PMT Level1] *= {'PMT1 - Body Exterior'}>}[Non Compliant (CAD)])

In the above scenario if no selections are made in PMT Level1 all graphs will show, if a selection is made on PMT level1 only that PMT level chart will calculate.

option2)Add a Calculation Condition for Each chart as below(in General Tab)

For PMT 3 chart add below condition

= if(WildMatch(concat(DISTINCT [PMT Level1]),'*PMT3*')>0,1,0)

For PMT 2 chart add below condition

= if(WildMatch(concat(DISTINCT [PMT Level1]),'*PMT2*')>0,1,0)

in the above scenario only selected PMT's will be show in case of no selections made no chart will be shown

You can also change the custom error message shown

[#4]

Hi Vineeth,

This is almost close to what I require. Still I have some questions on this. If you see the y-axes are not aligned properly. I have highlighted that below.

When we are working with grid, we are missing the Y-axis alignment. We need Y-axis for all the PMTs to be aligned with each other. How to achieve this? Is there any way to do it in container? I didn't see any option like this in container.

Abhijit

[ckulp]

Hi, 

Have there been any solutions to model what the OP included here? I am similarly attempting to create a stacked bar chart that will include 2 dimensions and 2 measures. This is basically what I want to show: Actual vs. Budget for each month during a Fiscal year. Actual and Budget are 2 different measures. The bar will represent the totals, but I would like that segmented by Category so it is a stacked bar. I can't seem to add this second measure. Thanks