14 Replies Latest reply: Nov 21, 2017 9:54 AM by Daniele Caprelli

# Values on the top of the line and down

Hi look at picture, i have this kind of chart, i want put for the first line the value on the Top (relative to the line) and for se second line the value Down (relative to the line) otherwise i can't read all values, is possible?

• ###### Re: Values on the top of the line and down

There is no direct way to avoid an overlapping of values completely - just some workarounds. For example playing with various options to adjust the scaling or using several charts which are overlapping eachother. My favourite approach would be to use a dual-expressions and adding some line-breaks to move the values - I mean something like:

dual(num(sum(YourValues), '#.##0,00') & chr(10) & chr(10), sum(YourValues))

- Marcus

• ###### Re: Values on the top of the line and down

but where do you put this kind of expression?

• ###### Re: Values on the top of the line and down

Within the normal expression tab as replacement to your existing expression maybe in one expression or with a reversed logic of the line-breaks (not at the bottom else on top) in the other expressions, too.

This meant, I haven't mentioned it, that you need for each line a separate expression and for it quite probably a set analysis to differ which line displayed what.

I haven't tested it if this approach could be applied within a chart where a dimension defined the lines and only a single expression is used. If your chart is of this kind you could try if you could query the dimension within the dual too.

To make more clearly here a few further examples how it could be look like:

dual(YourExpression & chr(10) & chr(10), YourExpression) // simplified to the origin suggestion

dual(chr(10) & chr(10) & YourExpression, YourExpression) //reversed logig

dual(if(YourDimension = 'XYZ', chr(10) & chr(10), '') & YourExpression, YourExpression)

- Marcus

• ###### Re: Values on the top of the line and down

Sorry but i tried to did that but it not start, perhaps not understand look my picture... what i need to do in this expression i have?

the first expression is Budget, and the secong id Actual

• ###### Re: Values on the top of the line and down

Do it with your budget-expression by replacing:

dual(YourExpression & chr(10) & chr(10), YourExpression)

the bold YourExpression with your used expression: ((sum(BUD.....) *100

- Marcus

• ###### Re: Values on the top of the line and down

Hi i did it but it not change nothing in my visualization

• ###### Re: Values on the top of the line and down

There is another important point for this. The formatting within the tab numbers must be on expression-standard then otherwise would be the formatting of the expressions ignored.

- Marcus

• ###### Re: Values on the top of the line and down

So what i need to do? i use this formatting you sent me in normal mode you sent me, and the formatting in tab numbers is normal, is: #.##0,00;(#.##0,00);-

• ###### Re: Values on the top of the line and down

Within the tab numbers mustn't be set any format for this expression.

- Marcus

• ###### Re: Values on the top of the line and down

Ok, i understand it start with that!! so for the first line i put more up the labels,

for the second line i wanna put down the line the label, how?

• ###### Re: Values on the top of the line and down

Try it  with this for the first line:

dual(YourExpression & chr(10) & chr(10), YourExpression)

and this for the second line:

dual(chr(10) & chr(10) & YourExpression, YourExpression) //reversed logig

Further you could also try to add some more line-breaks: chr(10).

- Marcus

• ###### Re: Values on the top of the line and down

Hi for the first line is OK

for the second line it not put down the line but only up

• ###### Re: Values on the top of the line and down

I believe really below the line won't be possible else a rather small adjustment to the origin position. A further option which might be useful in any way might be within the tab presentation the displaying within the segments:

- Marcus

• ###### Re: Values on the top of the line and down

No, it not do that..... i think is not possible so