Stacked Bar with Grouping of Dimentions

[#1]

Hi Experts,

I need to create a stacked bar with two dimensions.

This one is just a sample graph I have created in excel and made changes according to my requirement in paint. But I need to depict the same in Qlikview. I tried to add those two dimensions one after other while creating the graph but its not giving me the required result. Also I want to group them (make them separate) according to Level 1 dimension.

Thanks in Advance,

Abhijit

[#2]

Hi Sorry about that.

It was a typo. Hereby I am sharing the sample reduced data file. I tried with Varsha's approach. But still it needs furnishing.

varshavig12‌I tried with your approach. As I have 5 higher level dimensions, its divided in two blocks and scroll bar appears.

Abhijit

[#3]

Hi Avinash,

I have attached a sample file to Vinoth's reply. Please have a look at it.

Thank You,

Abhijit

[#4]

Share your data, your graph looks fine to me. I just wanna check the data.

[varshavig12]

Hi Abhijit,

1. I don't know whether it is possible to suppress the highlighted part.

2. Doted partition is because of trellis. Go to Properties --> Dimension --> Trellis

[#6]

Thank you Varsha!

I will update this thread if I get something to work around the solution.