Split string in multiple lines in bar chart dimension

[#1]

Hi All,

I am having a requirement in one of my qlikview report.

I have a bar chart with expression as sum(amount) and dimension as DQ_Issue.

The DQ_Issue field will contain long string values(upto 200 characters with space between words).

So if I use DQ_Isssue as dimension the value won't be visible completely in the graph.

I want to split the long string to multiple lines and then keep as a dimension in the bar chart.Also it should be alighed at centre

How I can i split the string?

Please suggest your ideas if any.

Thanks in advance.Any help would be greatly appreciated

Thanks and Regards,

Praveena

[mark_casselman]

Rob,

Very nice workaround! It works perfectly.

Two suggestions on the script:

I get a red underline in the script on the line

concat(Split, chr(10), SplitId) as $(vSplitField)

I think it should be

concat(Split & chr(10)) as $(vSplitField)

And line

GROUP BY Title

Should be

GROUP BY $(vField)

Regards,

Mark