Limit characters of dimmension

[#1]

I have dimmensions with a lot of charaters for example "company of bla bla bla bla 123123123"

How i limit this?

Thank you

Greetings.

[Anonymous]

depending on your object type

e.g. barchart

goto properties/presentation

Limit legends characters to number you need

[alexandros17]

Edit your dimension then write:

If(Len(MyDim) > 10, left(myDim,10), myDim)

where myDim is your dimension and 10 is the number of cher to show

let me know

[#4]

Mmm this is useful but i'm ussing jerarquic dimmension what i have to do ?

Thank you

[alexandros17]

You mean cyclic or dropdown?

In this case when you build the Group click on the dimension then in the label use my expression ...

[#6]

Cyclicm ok it would be something like this

If(Len('JERARQUIC') > 10, left('JERARQUIC',10), 'JERARQUIC')

[maxgro]

if you want the first n of a dimension

I think you can just use left(dimension, n)

[Anonymous]

be aware  that if there are identical text in the first 10 characters those values will be calculated as 1 dimension

Company of Africa

Company of Americe

Company of Australia

Company of Europe

will all be put together in

Company of

and you get not the correct values