Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combo chart - a stack bar and line issue

Hi,

I have created a combo chart, with 2 expressions and 2 dimensions and 2 axis. When both the expressions are enabled.  The stack bar turns into a group bars, when the line expression is disabled, the other expression is shown in stack bar. The line expression is an aggregate expression i.e  I am doing aggregate of one of the dimensions, where as the bar expression is just a sum.

I am expecting like the below one which is made in excel.

expected.JPG.jpg

but I am getting like this when line expression is enabled.

actual.JPG.jpg

How do I again aggregate the dimension 2 ( having values like An, Cr, Pr,Sa, UL) and show it in stack format. The line expression is aggregated over dimension 1( having values like Ag,Ba,Co,In).

Thanks in advance

Lax

1 Reply
CELAMBARASAN

You cannot use stacked option in Combo chart.

You can have 2 charts and make it one as Transparent background.

For your case

Line Chart: 1 dimension, 1 expression, it should be lower.

Bar Chart (Stacked): 2 dimension, 1 Expression, Background should be transparent(Colors tab --> Frame Background). should be above the line chart.