topic Re: Club two expressions from a set of 4 into a stacked bar chart in QlikView

Club two expressions from a set of 4 into a stacked bar chart

Fri, 20 Nov 2020 18:02:30 GMT

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?

Re: Club two expressions from a set of 4 into a stacked bar chart

Gysbert_Wassenaar — Tue, 10 Mar 2015 08:55:08 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Club two expressions from a set of 4 into a stacked bar chart

Tue, 10 Mar 2015 09:29:50 GMT

Hi Gysbert,

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)

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

Re: Club two expressions from a set of 4 into a stacked bar chart

Gysbert_Wassenaar — Tue, 10 Mar 2015 09:39:39 GMT

Can you post a source data file and the expressions you used?

Re: Club two expressions from a set of 4 into a stacked bar chart

Tue, 10 Mar 2015 09:51:01 GMT

Sorry, won't be able to post the data here either.

Following expressions were used to derive the first graph

Count( {<[Type]={'Open'}>} DISTINCT [Ticket No.])

Count( {<[Type]={'Closed'}>} DISTINCT [Ticket No.])

Count( {<[Dept]={'A'}, [Type]={'Open'}>} DISTINCT [Ticket No.])

Count( {<[Dept]={'A'}, [Type]={'Closed'}>} DISTINCT [Ticket No.])

Re: Club two expressions from a set of 4 into a stacked bar chart

Gysbert_Wassenaar — Tue, 10 Mar 2015 09:57:45 GMT

Sorry, but I still don't understand. You want two bars, yes? One Open and one Closed. Then you want Stacked segments for Dept A in both the Open and Closed bars . But with only one department... there's nothing to stack.

Re: Club two expressions from a set of 4 into a stacked bar chart

Tue, 10 Mar 2015 10:07:27 GMT

Yes, the requirement is two bars. The value for Dept A is essentially a subset of the total value being depicted in both the Open and Closed bars. The Dept A value needs to be made visible in the Open and Closed bars with a different colour so that it can be identified.

Re: Club two expressions from a set of 4 into a stacked bar chart

Gysbert_Wassenaar — Tue, 10 Mar 2015 10:34:39 GMT

I think you'll need to create either a new dimension in the script or a synthetic dimension. See attached example.

Re: Club two expressions from a set of 4 into a stacked bar chart

aveeeeeee7en — Tue, 10 Mar 2015 10:44:48 GMT

Incredible Stuff.

Gysbert Sir you Beauty.

Regards

Av7eN

Re: Club two expressions from a set of 4 into a stacked bar chart

Tue, 10 Mar 2015 11:13:12 GMT

Amazing!

Works perfect..

Thanks for sharing this very useful concept!