Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

tauceef9
Contributor

how to merge 2 measures into 1 in bar chart

Hello Everyone,

In one of our requirement we have to display a bar chart with 2 measures but both measures should be shown in single bar.

It's like this: We have to display number of open incidents and number of open incidents which have missed their SLA.

as the 2nd measure is a part of 1st one only clients are asking to have only one bar which will show the overall open count and with in the same bar missed count should also come and both the values should be displayed.

Please share if there's any option to create this.

Regards,

Tauceef

1 Solution

Accepted Solutions
tauceef9
Contributor

Re: how to merge 2 measures into 1 in bar chart

Closing this post as we have solved it by dividing the charts into 2 and used AM Combo with Grouped dimensions to merge 2 measures into one.

Thanks a lot for all your support.

Regards,

Tauceef

6 Replies
jwjackso
Contributor III

Re: how to merge 2 measures into 1 in bar chart

brianrmacdonald
Contributor

Re: how to merge 2 measures into 1 in bar chart

Also have a look at the expandable stacked bar chart on Qlik Branch.  I have used it in situations like this.  It can be very helpful.

http://branch.qlik.com/#!/project/57ee35afd9b7fc645546244e

tauceef9
Contributor

Re: how to merge 2 measures into 1 in bar chart

Hi Jerry,

I have tried the Stacked bar but not working for me.

In our case we actually have to display 4 measures in a single chart.

Like eg. Incidents Open & Incidents Breached SLA

              SR Open & SR Breached SLA

If I will use bar chart all 4 will come in a single bar but I want 2 bars, one for Incident(covering open and breached) and one for SR(covering open and breached).

Regards,

Tauceef

tauceef9
Contributor

Re: how to merge 2 measures into 1 in bar chart

Hi Brian,

I am not getting any option to add multiple measures in this extension.

Would you please help me out.

Regards,

Tauceef

anderson_system
New Contributor III

Re: how to merge 2 measures into 1 in bar chart

Hi

could you post an example of the data you need to be displayed on the chart for ease of understanding?

thank you,

tauceef9
Contributor

Re: how to merge 2 measures into 1 in bar chart

Closing this post as we have solved it by dividing the charts into 2 and used AM Combo with Grouped dimensions to merge 2 measures into one.

Thanks a lot for all your support.

Regards,

Tauceef

Community Browser