Spaces in the title of each worksheet

[andrew_smith200]

I am trying to enter the following into the title of my worksheet:

'Name                                                               MyName'

Unfortunately Qlik displays this like this:

'NameMyName' - it doesn't recognise the white space.

I have tried ='MyName '&chr(32)&chr(32) etc & 'MyName' but that still yields the same results.

Any one have any ideas on how to overcome this?

[lorenzoconforti]

This works for me in the title expression (Sheet properties):

 ='MyName ' & chr(32) & chr(13) & chr(32) & chr(13) & chr(32) & chr(13) & chr(32)  & 'MyName' 

I think what happens is that consecutive white spaces are being trimmed. The workaround is to trick Qlik into thinking they are not consecutive thus adding the line brake chr(13)

[andrew_smith200]

Thanks but it didn't work for me - is this anything to with the browser?

[lorenzoconforti · Accepted solution]

I tried it now in Chrome and indeed it doesn't work for me either

Try this

='MyName ' & chr(127) & chr(127) & chr(127) & chr(127)  & 'MyName' 

[andrew_smith200 · Accepted solution]

Yes that did it – many thanks