Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

1 Solution

Accepted Solutions

Re: Change style of total line

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


talk is cheap, supply exceeds demand
7 Replies
Not applicable

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>')

Not applicable

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()).


talk is cheap, supply exceeds demand
Not applicable

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>')


talk is cheap, supply exceeds demand
Not applicable

Re: Change style of total line

That did the trick.... Thanks!

Re: Change style of total line

Excellent solution Gysbert!

-Rob

Community Browser