topic Multiple graphs for expressions in QlikView

Multiple graphs for expressions

Fri, 17 Jan 2014 14:45:33 GMT

I have a line chart with two dimensions, let's say Year and Continents (EUR, ASIA, AUS).

I use various conditional expressions. In the simplest form, I have two expressions. A sum of Values1 and a sum of Values2. Normally, for 1 expression I get 3 graphs (one for EUR, one for ASIA and one for AUS) with Year on x axis. But if I put a second expression I don't get 3 more graphs as I would expect, but 1 for Values1 (total for all continents) and 1 for Values2.

I want to have a number of graphs that is multiples of 3. 3 for one expression, 6 for two etc. That should be possible, right?

Re: Multiple graphs for expressions

whiteline — Fri, 17 Jan 2014 15:17:53 GMT

Hi.

It's chart limitations.

More than one expression go to legend, and some dimensions are ignored.

You have to create separate expressions for EUR, ASIA, AUS.

Or you can create one complex expression with one common dimension.

Also you can try to use overplayed transparent objects depending on your requirements.

Re: Multiple graphs for expressions

jaimeaguilar — Fri, 17 Jan 2014 16:06:13 GMT

Hi,

can you please post an example so it can be clearer?

regards

Re: Multiple graphs for expressions

Mon, 20 Jan 2014 07:47:13 GMT

Thanks for the answer. I think option 1 and 3 might work. But generally I don't like customized solutions but general, so as not to update the document when new data is added.

The transparent object might work, I have never thought of that! Also I can try the separate expressions but as I said they have to be updated if something is added. A complex expression with one dimension will not produce the 6 graphs though.

Re: Multiple graphs for expressions

whiteline — Mon, 20 Jan 2014 19:26:51 GMT

Hi.

You don't have to update it.

Create secondary dimension =ValueList('Sum1', 'Sum2')

And try expression =if(ValueList('Sum1', 'Sum2')='Sum1', Sum(Value1), Sum(Value2))