Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
Not applicable

How to to club two expressions from a set of four into a pair of stacked bar chart

Hi,

I have a requirement to display the following in a bar chart.

Dimension:

Month

Expressions:

1. Open Tickets

2. Closed tickets

3. Open tickets for department A

4. Closed tickets for department A

The bar chart should have two bars " Open ticket and Closed ticket" being displayed for a single dimension "Month" but the bars should be stacked and display 'Open tickets for department A' and 'Closed tickets for department A' in the respective two bars itself.

Looking for a solution to this problem. Is it feasible?

1 Solution

Accepted Solutions
Not applicable

Re: How to to club two expressions from a set of four into a pair of stacked bar chart

6 Replies

Re: How to to club two expressions from a set of four into a pair of stacked bar chart

Could you attached your data/file?

Not applicable

Re: How to to club two expressions from a set of four into a pair of stacked bar chart

Hi Robert,

Won't be able to attach the data/qvw but attaching a snapshot of how the bar chart looks for the four expressions. (Snip.jpg)

Snip.JPG

The data for 'Dept A Open' and 'Dept A Closed' is a subset of the entire data set for 'Open tickets' and 'Closed tickets' respectively.

The objective is to try and show the subsets in a pair of bars for the 'Open tickets' and 'Closed tickets' (Snip2.jpg) as a stacked bar chart generally looks like

Snip 2.JPG

Partner
Partner

Re: How to to club two expressions from a set of four into a pair of stacked bar chart

Hi Bhupesh,

please see the attached.

Regards

Andy

Not applicable

Re: How to to club two expressions from a set of four into a pair of stacked bar chart

Hi Andrew,

I had a look at your expressions in the qvw.

The value of Sum(DeptAOpen)  and sum(DeptAClosed) should be speparately visible in the same two bars of the graph- “All Open” and “All Closed” but with a different colour so that they can be identified.

Re: How to to club two expressions from a set of four into a pair of stacked bar chart

You have similar problem with solution here:

grouped / stacked bar graph

Not applicable

Re: How to to club two expressions from a set of four into a pair of stacked bar chart