topic Re: Can I keep space in chart title? in QlikView

Can I keep space in chart title?

Thu, 15 Aug 2013 22:31:07 GMT

Hello Everyone,

I try to adjust Chart Title caption by adding space.I add Title Caption =' Comments' to adjust title caption alignment. Please see attached pic. But those space will gone after I publish this application to upfront.

Do you have any idea to adjust the Chart Titlte position flexibly? Or anyway I can keep those space I add to title.

Thanks,

Dust

Re: Can I keep space in chart title?

sushil353 — Thu, 15 Aug 2013 22:46:48 GMT

add space using chr(10) or chr(39)

HTH

Sushil

Re: Can I keep space in chart title?

Thu, 15 Aug 2013 23:44:49 GMT

Thank you very much - Sushil!

Can you tell more how to code this? Can I say =chr(10)&chr(39)&'Comments'?

Best regards,

Dust

Re: Can I keep space in chart title?

Anonymous — Tue, 29 Oct 2013 13:53:09 GMT

Hi Dust,

Did u find solution how to add space because I am facing same here.. How to code it?

Re: Can I keep space in chart title?

sushil353 — Wed, 30 Oct 2013 04:33:31 GMT

Hi Praveena,

You can add spaces using chr() function..

chr(9)- one space

chr(10)- new line

try and test above in text box like ='Praveena'&chr(9)&chr(9)&'velagapudi'

HTH

Sushil

Re: Can I keep space in chart title?

Wed, 30 Oct 2013 05:13:50 GMT

Hi Dust,

You can try something like ' ' & ' ' Comments ' ' & ' ' & Comments1 etc.

' ' gives one space and this way you can manage spaces accordingly.

Thanks!!

-Yojas

Re: Can I keep space in chart title?

Wed, 30 Oct 2013 10:33:20 GMT

Hi Praveena,

You can try =' words'

Some chart is working.

Thanks,

Dust

Re: Can I keep space in chart title?

Wed, 30 Oct 2013 10:54:17 GMT

The simplest way is to use "header alignment" in "Caption" tab, right?

HTH

Re: Can I keep space in chart title?

Wed, 30 Oct 2013 11:26:49 GMT

Thanks -- HTH.

Sometimes I need more flexible aligment on title position.

Re: Can I keep space in chart title?

Wed, 30 Oct 2013 12:56:39 GMT

Hi Dust,

If you got your Solution then please mark this conversation as Correct so that people use it for further referece.

- Yojas

Re: Can I keep space in chart title?

Anonymous — Wed, 30 Oct 2013 13:49:02 GMT

I tried every option given here but could not find direct solution to ceate enough space in between two words; it shows fine in desktop view but cant find that space in web view..

I did workaround by creating text box and placing at center with transparent, corner title is directly from title..

Re: Can I keep space in chart title?

Wed, 30 Oct 2013 13:59:52 GMT

Hi Praveena,

Yes, you are right. The space will dispear when publish to access point. I will unmark my answer as correct and keep the discussion going on.

Thanks,

Dust

Re: Can I keep space in chart title?

Wed, 06 Jan 2016 18:31:56 GMT

Hi,

Make the Title blank (keep "Show Title in Chart" as Checked) and add the text that you want to add as the chart title in "Text in Chart" under Presentation tab. Format the font as necessary. Apply the changes. You can place/move the text box while pressing Ctrl+Shift in the chart.

Re: Can I keep space in chart title?

rwunderlich — Wed, 06 Jan 2016 23:21:20 GMT

The solution to maintaining spaces in webview is to use chr(160) for the space characters. e.g.

=repeat(chr(160),8) & 'My Title'

will keep 8 leading spaces.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Can I keep space in chart title?

Mon, 25 Jan 2016 15:12:42 GMT

Thank you very much - Rob. Your solution works perfectly. Appreciate!

Re: Can I keep space in chart title?

emoncisvais — Mon, 27 Feb 2017 23:04:08 GMT

Is there a number for the Chr function that works as a tab space? Like in Chr(9).

Re: Can I keep space in chart title?

rwunderlich — Tue, 28 Feb 2017 01:50:20 GMT

‌Yes, chr(9) will render a tab character. I believe tabs would ignored in the context of the Ajax HTML client though and would have no effect.

-Rob

Re: Can I keep space in chart title?

emoncisvais — Tue, 28 Feb 2017 03:51:55 GMT

Thank you very much.

Enviado desde mi smartphone Samsung Galaxy.

Re: Can I keep space in chart title?

elmelavi — Wed, 30 Nov 2022 12:32:50 GMT

User This:

KEEPCHAR([Field],'A B C D E F G H I J K L M N O P Q R S T U V W X Y Z')

WHICH MEAN ADD SPACES BETWEEN CHRACTER