Stacked/Grouped Bar Chart

[#1]

Hi -

I've attached a Qlik Sense file as an example for what I am trying to accomplish. I have a grouped bar chart right now with 6 bars. I am trying to modify this bar chart, so it only shows two bars. One bar I would like to be D+A and the other bar I would like to be C+B. Ideally, there would be two bars that represent 23 and 9 hours respectively. The remaining categories of E & F don't need be shown or included at all. How can I accomplish this? If you could update my example file with the answer, that would be great!

Thanks,

Laura

[Gysbert_Wassenaar]

Create an new dimension in the Data Load Editor to group the Type values in bar groups

BarGroups:

Load * Inline [

BarGroup, Type

D+A, A

D+A, D

C+B, B

C+B, C

];

The use that new dimension BarGroup in the bar chart instead of the Type dimension.