7 Replies Latest reply: Jul 18, 2013 10:57 AM by Rob Wunderlich

# Change style of total line

Hi all,

Wonder if anyone can help me with this one...

Using Qv11, on a line chat, I created a Total (Dimension Limits) wich I called 'Average'.

Now I wanted this 'Average' line to have a diferent style, so I inputed this formula into the Line Style of the expression:

=if(Source<>'Average','<S1>','<S4><W4>')

It doesn't work.. but if instead of average I put any other value of the field Source, then it works fine.

How can I make it work for the Total (Dimension Limits) created line?

Thanks you so much...

Kind regards,

Nuno

• ###### Re: Change style of total line

heyy

Try Using Total (Dimension Limits) instead of ' Average' in your expression

something like this

=if(Source<>',Total (Dimension Limits)'<S1>','<S4><W4>')

• ###### Re: Change style of total line

Seriously... when I say Total (Dimension Limits) I mean enabling Show Total on Chart Properties, Dimension Limits pane.

Can anyone help?

• ###### Re: Change style of total line

You can use the rank function. The Others category will always have rank 1. Suppose your expression for the line values is avg(Amount). Then you can set the color of the Total line that's created by enabling the Others option with: if(rank(avg(Amount))=1,red()).

• ###### Re: Change style of total line

Thanks.. but it didn't work. Rank 1 doesn't point to the Total line (or the Other line) using your suggested method.

• ###### Re: Change style of total line

Ah, the Total option. Ok, try if(isnull(Source), '<S4><W4>')

• ###### Re: Change style of total line

That did the trick.... Thanks!

• ###### Re: Change style of total line

Excellent solution Gysbert!

-Rob