topic Line chart, Multiple expressions, two dimensions and total in QlikView

Line chart, Multiple expressions, two dimensions and total

mikael_cleuziou — Wed, 23 May 2012 12:27:03 GMT

Hello,

In a line chart, when we use multiple expressions, qlikview doesn't used the second dimension and aggregate.

I have joined an example. In the first sheet, you can see four charts. I would like all these chart in one!

Is it possible with Qlikview? Is valuelist a good way to find the solution?

Thanks for your help.

Mika

Line chart, Multiple expressions, two dimensions and total

john_duffy — Wed, 23 May 2012 12:52:44 GMT

Hello Mika.

I believe with a line chart you can have 2 dimensions and 1 expression or 1 dimension and multiple expressions.

If you have multiple dimensions with 2 expressions, the first dimension will be used and other dimensions will be ignored.

John.

Line chart, Multiple expressions, two dimensions and total

mikael_cleuziou — Wed, 23 May 2012 13:44:40 GMT

Hello,

Thanks for your answer. It's incredible! It means that you can't have in one line chart your revenue $ and charge $ by time and country. It sounds so easy, I don't understand!

Thanks,

Mika

Re: Line chart, Multiple expressions, two dimensions and total

jcampbell — Tue, 10 Jun 2014 21:04:31 GMT

You can do it. Just go to the Properties of your Object, choose "Axes", select the second Expression and change the "Position" to "Right (Top)". By default your first Expression will be "Left (Bottom)". See the attached example.

Re: Line chart, Multiple expressions, two dimensions and total

Wed, 03 Feb 2016 21:13:33 GMT

There is a problem here - if you have two dimensions and two expressions these two expressions will not be presented by individual line per each second dimension as it works when you have two dimensions and just one expression. The question is - is it possible to have individual line for each second dimension per each expression across first dimension?

See example in attachment