topic Re: Combo Chart - 2 Dimension 2 Expressions in QlikView

Combo Chart - 2 Dimension 2 Expressions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Combo Chart - 2 Dimension 2 Expressions

Chanty4u — Thu, 14 Apr 2016 02:10:39 GMT

Hi settu_periasamy

he is the right person to give the solution to u

Re: Combo Chart - 2 Dimension 2 Expressions

clondono — Thu, 14 Apr 2016 02:48:32 GMT

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) ! !

Re: Combo Chart - 2 Dimension 2 Expressions

clondono — Thu, 14 Apr 2016 03:00:21 GMT

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

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

Re: Combo Chart - 2 Dimension 2 Expressions

settu_periasamy — Thu, 14 Apr 2016 03:04:16 GMT

Everybody is a right person 🙂

May be like this?

Re: Combo Chart - 2 Dimension 2 Expressions

Chanty4u — Thu, 14 Apr 2016 04:20:25 GMT

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

Re: Combo Chart - 2 Dimension 2 Expressions

Anonymous — Thu, 14 Apr 2016 16:35:16 GMT

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 !!!

Re: Combo Chart - 2 Dimension 2 Expressions

Anonymous — Thu, 14 Apr 2016 16:35:46 GMT

That's what I needed.

Thank you very much!