Combo Chart - 2 Dimension 2 Expressions

[Anonymous]

Hi all.

I am trying to make a combo chart with 2 dimensions and 2 expressions.

I am facing a issue here and I can not achieve a solution. What I need is a chart as the image above.

But I can't do it in Qlikview . I was trying to overlap two graphs but neither with a line chart I can achieve what I need.

Thank you for the help.

[Chanty4u]

Hi settu_periasamy 

he is the right person to give the solution to u

[clondono]

You can create a Cyclic group with the the 2 dimensions "GRUPO_ECONOMICO" and "MESANO" and for expressions use Sum(FATURADO) and Sum(META) using the second expression as a line. (See attached) ! !

[clondono]

Or if you need to have them in the same view, create a calculated dimension:

=GRUPO_ECONOMICO & CHR (10) & 'MESA=' & MESANO

[settu_periasamy · Accepted solution]

Everybody is a right person 🙂

May be like this?

[Chanty4u]

From my point of view Ur r champ in this type of issues.

[Anonymous]

That's exactly what I was looking for. I needed a drilldown in the second dimension but I solved the problem with a conditional clause.

Thank you !!!

[Anonymous]

That's what I needed.

Thank you very much!