Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit characters of dimmension

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

How i limit this?

Thank you

Greetings.

7 Replies
Anonymous
Not applicable
Author

depending on your object type

e.g. barchart

goto properties/presentation

Limit legends characters to number you need

alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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

Thank you

alexandros17
Partner - Champion III
Partner - Champion III

You mean cyclic or dropdown?

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

Not applicable
Author

Cyclicm ok it would be something like this

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

maxgro
MVP
MVP

if you want the first n of a dimension

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

Anonymous
Not applicable
Author

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