topic Re: Re: Graphing multiple Expressions for multiple selections on a Dimension. in QlikView

Graphing multiple Expressions for multiple selections on a Dimension.

Mon, 28 Apr 2014 22:07:45 GMT

Is there a way to chart multiple expression that share the same dimensions for multiple selections without resorting to overlay charts? For example my dimensions are SYS_DATE and SYSTEM with an Expression of (AVG_DAILY_BUSY). With one expression I can select 1 or multiple SYSTEMs and each will get its own line on the chart. With the addition of a second expression (MAX_HOURLY_BUSY) when I select a System it charts both expressions for the SYSTEM dimension, but one can no longer chart multiple systems, in fact selecting multiple systems now results in a blank chart.

With one expression:

With two expressions one dimesion selected:

With two expresions multiple dimensions selected:

What I really want is to be able to select one to multiple Systems and chart both expressions for all selected. I know I can do this with overlays, but thinking there is a much more elegant solution here?

Re: Graphing multiple Expressions for multiple selections on a Dimension.

MarcoWedel — Mon, 28 Apr 2014 22:58:00 GMT

can you please share the qvw?

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 00:04:43 GMT

Maybe trellis chart?

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Clever_Anjos — Tue, 29 Apr 2014 00:43:30 GMT

Not using line chart, because it does not stack.

Another point is that a graph with more than 7 or 8 lines can be very messy and hard to understand

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 13:59:02 GMT

Here is what my graph looks like in EXCEL, this is what I wish to duplicate with my QV Dashboard:

As you can see the expression are such that the groupings will alway be seperate and quite clear. Seems there should be a simple way to do this in QV... I'm actually graphing three Expression in this example.

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Greg_Williams — Tue, 29 Apr 2014 14:03:27 GMT

Have you tried to associate in the Axis tab (chart properties) - the appropriate expressions with the Primary or Secondary axis (i.e. left and right axes)?

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 14:13:28 GMT

Hi Greg, You did teach me something new as I was unaware of this feature , but it doesn't solve my problem. Setting the primary expression position to left and secondary expression position to right on the Axes Tab resulted in seperate scales for each, but did not enable graphing of multiple selected dimension for each expression.

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Clever_Anjos — Tue, 29 Apr 2014 14:25:37 GMT

A possible workaround...

Instead of having two dimensions, please use only one calculated, concatenating dimensions.

Example:

=Dimension1 & Dimension2

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 14:55:06 GMT

Hi Clever, not sure I understand what you are proposing here. My Dimensions currently are SYSDATE and SYSTEM and myExpressions are AVE_DAILY_BUSY MAX_HOURLY_BUSY.

Concatinating my Dimensions results in a graph like this, which accumulates the values for the SYSTEM Dimension rather than graphing each SYSTEM as a seperate line:

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Clever_Anjos — Tue, 29 Apr 2014 17:00:40 GMT

Sorry my fault, I was wondering 3 dimensions + 1 expression..

You have 2 + 2

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Clever_Anjos — Tue, 29 Apr 2014 17:01:50 GMT

Another way,

Two overlayed line graphs, each one with one expression.,the top one, with transparente background and hidden axes

Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 18:00:10 GMT

Hi Clever, That is exactly what I was trying to avoid....read original thread. I am hoping there is a far more elegant solution in QV for this problem It can easily be accomplished with Excel and also Tableau.....

Re: Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 19:01:49 GMT

Lewis,

i hope you like it

Let me know if it is what you are looking for.

regards

Darek

Re: Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 20:04:15 GMT

Hello Dariusz, I like it! Absolutly Brilliant!!!! It worked

You solution was definitely elegant, but seems to me that QV should have a more straightforward way of handling this scenario.

Anyway, many thanks!!!

-Lew

Re: Re: Graphing multiple Expressions for multiple selections on a Dimension.

Tue, 29 Apr 2014 20:18:29 GMT

Lewis,

if it will be too easy, i will have no work

as a workaround there is always Community ....

And, next time you will know and not somebody else, so your value grows up

regards

Darek