topic Re: Wrap X axis labels in two lines in QlikView

Wrap X axis labels in two lines

soha1902 — Mon, 06 Apr 2015 05:53:15 GMT

Hi All,

I have long X axis labels in my bar chart. I want to wrap my labels in two lines.

I using following expression in dimension:

Replace(Name , ' ' ,chr(13)) then It will wrap name in two lines.

But My Requirement is if Len(Name) is greater then 15 it will start new line by 3rd blank space. The expression which I am using there it is showing next line by first blank space.

Please help .

Thanks,

Re: Wrap X axis labels in two lines

mohammadkhatimi — Mon, 06 Apr 2015 06:23:26 GMT

Add Code in Calculate demension

where State= Dimension

=left(State, findoneof(State, ' ', ceil(substringcount(State, ' ')/2))) & chr(13) & chr(10) & right(State, len(State) - findoneof(State, ' ', ceil(substringcount(State, ' ')/2)))

Try above code will help you.

Regards,

Mohammad.

Re: Wrap X axis labels in two lines

anbu1984 — Mon, 06 Apr 2015 06:24:21 GMT

=If(Len(Name) > 15, Left(Name,FindOneOf(Name,' ',3)-1) & Chr(13) & Mid(Name,FindOneOf(Name,' ',3)+1) ,Name)

Re: Wrap X axis labels in two lines

tresB — Mon, 06 Apr 2015 06:32:37 GMT

Try:

=If(Len(Name)>15,Left(Name,Index(Name,' ',3))&chr(13)&Right(Name,Len(Name)-Index(Name, ' ',3)),Name)