topic How can I do a stacked bar chart with a line as well? in QlikView

How can I do a stacked bar chart with a line as well?

cliff_clayman — Sat, 16 Nov 2024 18:25:10 GMT

I am trying to create a stacked bar chart that also has a line as well. I cannot use a combo chart because it does not allow me to do stacked. I have one dimension that is a ValueList and another dimension that has more than one value. I have two expressions, one for the bar graph and one for the line. How can I get this to work?

Re: How can I do a stacked bar chart with a line as well?

basav — Thu, 02 Jul 2020 05:44:36 GMT

Hi Cliff,

Are you looking for something like this.

Please find the QVW attached.

Re: How can I do a stacked bar chart with a line as well?

cliff_clayman — Thu, 02 Jul 2020 13:55:36 GMT

It is, but I have two dimensions and that seems to be causing me not to do a stacked bar.

Re: How can I do a stacked bar chart with a line as well?

basav — Thu, 02 Jul 2020 14:41:19 GMT

Hi Cliff,

what kind of problem does it causing, is it in terms of any script error, or its just not visually good. Please explain. Also can you please post a sample data. That would really help the community to give you proper answer.

regards,

Basav

Re: How can I do a stacked bar chart with a line as well?

cliff_clayman — Thu, 02 Jul 2020 14:43:14 GMT

The option to do a stacked bar is greyed out when I have two dimensions.

Re: How can I do a stacked bar chart with a line as well?

basav — Thu, 02 Jul 2020 15:57:55 GMT

Hi Cliff,

Follow these steps:

1. Create A new chart with the combo, at first select only one dimension, and then add all the expression you want.

2. Select appropriate Display options for those expressions. In your case, select bar for two expressions, and Line for the other expressions. Click Finish.

3., Again click on the properties, then go to Style tab and select stacked. After that go to Dimensions tab, add the one more dimension. This should do the job.

At last, to have two Y-axis, one on left and one on the right. Go to Axes tab, Select the expression which has Line display options, and then under Position, please select Right.

cheers,

Basav

Re: How can I do a stacked bar chart with a line as well?

cliff_clayman — Mon, 06 Jul 2020 16:34:24 GMT

That method did not work. Does anyone else have a suggestion? I do not understand why this is so difficult to do within Qlikview...

Re: How can I do a stacked bar chart with a line as well?

basav — Tue, 07 Jul 2020 10:32:34 GMT

Hi Cliff,

Can you please upload a sample QVW. That would help us to find the solution.

regards,

Basav