topic Re: Line break in script in QlikView

Line break in script

Thu, 27 Nov 2014 09:31:42 GMT

Hi,

Is it possible to make a line break in the script? I use field values loaded in the script in a graph as axis values. The field values are text string and the length of the string needs to be divided in two rows. example:

Load inline [

nr, Data

1 abcdefghij klmn opqrst .....

what i would like to do is to insert a line break in field Data. The length of the string makes it difficoult to show on a graph axis.

Best regards

Anders

Re: Line break in script

morganaaron — Thu, 27 Nov 2014 09:56:21 GMT

Hi Anders,

If you need to divide it into two rows based on a count of characters or a split, use a calculated dimension. For a count use:

=Left(Data, X) & chr(10) & Right(Data, len(Data)-X) replacing X with however many characters you want on the first line.

If you want to break at every space, use:

=SubField(Data,' ',1) & chr(10) & SubField(Data,' ',2)...etc for however many spaces/rows you want.

If then in the axes tab you set the Dimension Axis labels to / or | you'll get all the lines appearing with the line breaks.

Re: Line break in script

giacomom — Thu, 27 Nov 2014 10:20:27 GMT

Hi Anders,

in addition to what Aaron says, if you just want to show part of the string (the first n characters) just to make the chart axis more readable instead, you can set the legend limit number in the Presentation tab of the chart properties window, as showed in the figure below:

Regards,

Giacomo

Re: Line break in script

Thu, 27 Nov 2014 12:50:44 GMT

almost there, i try to make 3 line breaks. 2 works fine but when i make 3 the text dissappear.

suggestions?

Re: Line break in script

morganaaron — Thu, 27 Nov 2014 13:15:02 GMT

Hi Anders,

Which of the options are you using? If it's the SubField script, putting:

& chr(10) & SubField(Data,' '.3) after the above statement should work.

Actually, just thought of a much simpler option. Use: Replace(Data,' ',chr(10)) instead - this will replace any space with a line break. Not sure how many this would take before running out of line space though!

If it's using the Left/Right statements you'll need to introduce a "Mid" statement as well - let me know if that's the case.

Re: Line break in script

Thu, 27 Nov 2014 15:24:48 GMT

thanks Aaron

Kind regards

Anders