topic Re: Wrap Dimension in QlikView

Wrap Dimension

Fri, 24 Jan 2014 08:05:42 GMT

Hello

I would like to know if there's a way to wrap text a dimension on a bar chart.

I have a bar chart with agent names as dimension and the names are pretty long. Is there a way I can wrap the text or get it to show fully?

Zama

Re: Wrap Dimension

tresB — Fri, 24 Jan 2014 08:13:19 GMT

Goto presentation tab->Limit Legends. You can restrict the number of characters you want to display on the dimension here.

Re: Wrap Dimension

Fri, 24 Jan 2014 08:15:56 GMT

Can try to put Chr(10) in between the string value. Chr(10) will give next line to the string.

Re: Wrap Dimension

Fri, 24 Jan 2014 08:46:12 GMT

Hi Tressco,

Its not working

Re: Wrap Dimension

Fri, 24 Jan 2014 08:46:50 GMT

Hi CS Khoo

Could you please give me an example please.

Re: Re: Wrap Dimension

tresB — Fri, 24 Jan 2014 09:43:17 GMT

PFA. Isn't this what you want?

Re: Wrap Dimension

Fri, 24 Jan 2014 10:40:06 GMT

Only the first 5 characters are showing and not all of the AAAAAAAAAAAAAAA and BBBBBBBBBBBBB etc.

Re: Wrap Dimension

Fri, 24 Jan 2014 10:54:49 GMT

Hi,

Try like this: change the "Primary dimension label" style to display text as diagnal. It is under Axes tab.

Re: Re: Wrap Dimension

tresB — Fri, 24 Jan 2014 11:09:56 GMT

It was my misunderstanding. What you want is not directly possibly in qv as of now, you can try an alternative like in attached sample. PFA

Re: Re: Re: Wrap Dimension

Anonymous — Fri, 24 Jan 2014 12:31:30 GMT

Zama

I have modified the qvw of tresesco and re-attached it.

Is this now the kind of thing you are after ?

It is bit rough & ready, but I am sure it could be polished up.

Best Regards, Bill

Re: Wrap Dimension

Fri, 24 Jan 2014 13:13:52 GMT

Hill Bill,

Can you let em know what does the middle things refers to (in this case 21)...

I understood that 5 refers to number of character on one single line. But not sure about 21

= mid(Dim , 21, 5 )

Re: Wrap Dimension

Fri, 24 Jan 2014 13:18:12 GMT

Also, what if i want to have another condition wherein it first searches if there is a space between the text.. For eg 'Capital Markets'.... Capital should be on line 1 and markets on second line for that particular bar . if there is no space then it can use your current code of divinding it into 5 letters each line

Re: Re: Wrap Dimension

Anonymous — Fri, 24 Jan 2014 13:34:59 GMT

Yousuf

The QlikView Help is always the first place I go to for information on QlikView functions. Below I have pasted in the entry for mid()

mid(s, n1[, n2 ])

Substring of the string s. The result is the string starting at character n1 with the length of n2 characters. If n2 is omitted, the function returns the rightmost part of the string starting at character n1. The positions in the string are numbered from 1 and up.

Example:

mid('abcdef',3 ) returns 'cdef'.

mid('abcdef',3, 2 ) returns 'cd'.

mid( Date,3 ) where Date = 970714 returns 0714.

mid( Date,3,2 ) where Date = 970714 returns 07.

For a more complicated example, see the index function below.

So from that you see that The result is the string starting at character n1 and n1 is 21 in this case.

Best Regards, Bill

Re: Re: Wrap Dimension

Anonymous — Fri, 24 Jan 2014 13:42:24 GMT

Yousuf

As I said earlier my qvw is a 'bit rough & ready, but I am sure it could be polished up'.

I have given you the principle. The polishing up you need to do will primarily be manipulating strings. I'd suggest you give it a go yourself, but first have a look in the QlikView Help at all the String Functions and see what such functions exist - you'll find your new friend the mid() function there as well.

If you have specific questions about any of these functions, then if you start a new thread here on the QlikCommunity, then I am sure your question will be answered.

Best Regards, Bill

Re: Re: Re: Wrap Dimension

Fri, 24 Jan 2014 15:25:25 GMT

Somehow i did what you suggested. But output is not coming as desired.....Please refer to the attachement.

Re: Wrap Dimension

Fri, 24 Jan 2014 16:28:25 GMT

I think they already gave you the ans... =D similar way, used chr(10)

Re: Wrap Dimension

Peter_Cammaert — Fri, 24 Jan 2014 16:42:47 GMT

Alternate display methods (because this will never lead to a satisfactory solution in all situations):

Cut the label as explained before by limiting the number of characters. Use the pop-up tooltip to display the full dimension value, or
rotate your chart 90deg to get more space for long dimension values (see chart properties->style)

Good luck,

Peter

Re: Re: Re: Re: Wrap Dimension

Anonymous — Fri, 24 Jan 2014 18:16:53 GMT

Yousef

My earlier suggestion does not work for Stacked Bar Charts.

But how about simply changing the bar orientation, see attached.

Best Regards, Bill