topic Re: to many dimensions in QlikView

to many dimensions

Anonymous — Tue, 09 Sep 2014 17:33:26 GMT

Hi,

I am having some issues with too many dimensions in the same chart.

As you can see in the attachment, I have a chart with Month (dim1) and TypeofCustomer (dim2). Then in the expression I have the sum of Revenues for 2014 (exp1).

When I try to add the cumulative for 2013 (exp2) and for 2014(exp3) the chart just explodes (see attachement 'explodes').

How can I manages this: having dim1 and 2 and all 3 exp in the same chart?

Any suggestions?

Re: to many dimensions

Gysbert_Wassenaar — Tue, 09 Sep 2014 17:37:10 GMT

You can't in one chart. What you can try is put two charts on top of each other and making the background and axes of the top chart transparent.

Re: to many dimensions

JonnyPoole — Wed, 10 Sep 2014 02:24:36 GMT

agree with below. Here is a sample i created awhile back to show a 2 dimension x 2 expression line chart. Its not doable short of an extension object, so it actually consists of 2 charts strategically layered over top of each other with the top chart having a transparent background.

It sort of works buts its kind of annoying. Let me know if you have any questions