Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sheetal1234
New Contributor II

space between 2 words on title of chart in qliksense

hi, I want to give space between 2 words on title of chart. eg.



P&L                                                                                 Rs. Cr


how can i do this in qliksense???

1 Solution

Accepted Solutions
arvind_patil
Valued Contributor III

Re: space between 2 words on title of chart in qliksense

Hi Sheetal,

May be like this:

='P&L '&'   '&'  Rs. Cr'


Thanks,

Arvind Patil

9 Replies
arvind_patil
Valued Contributor III

Re: space between 2 words on title of chart in qliksense

Hi Sheetal,

May be like this:

='P&L '&'   '&'  Rs. Cr'


Thanks,

Arvind Patil

sheetal1234
New Contributor II

Re: space between 2 words on title of chart in qliksense

Hi,

Thanks for prompt reply.

I tried your solution.

But it is not working..

brijesh_fofadiy
New Contributor III

Re: space between 2 words on title of chart in qliksense

Hi sheetal1234


Use this in an expression:

='P&L' & Chr(160) & Chr(160) & Chr(160) & ' Rs. Cr'

Chr(160) = Space

Ralf_Heukäufer
Contributor III

Re: space between 2 words on title of chart in qliksense

Hi you can try it with different Characters like:

='P&L '& chr(9) &'  Rs. Cr'


My ASCII Table


Character 9 isthe Tabulator for example.


But I think that doesn't help the title ignores every space with a split white more than one.



simon_minifie
Contributor III

Re: space between 2 words on title of chart in qliksense

Hi Sheetal,

You can use chr(), although you've got to play around with it.

If you add multiple chr(32) it seems to ignore all but the first one, so you end up with one space.

Got around it by alternating between chr(32) and chr(160).

='Test'&chr(32)&chr(160)&chr(32)&chr(160)&'Test2'

Maybe someone else has a cleaner solution.

Thanks,

Simon

bazil1990
New Contributor

Re: space between 2 words on title of chart in qliksense

Hi,

Plz try this

'P&L' & repeat(chr(160),8) &'Rs. Cr'

Here  chr(160) indicate 'Space'.

And 8 indicates that how many time you want to repeat space.

Thanks,

Bazil

OmarBenSalem
Esteemed Contributor

Re: space between 2 words on title of chart in qliksense

You can close the thread; here's your answer !

sheetal1234
New Contributor II

Re: space between 2 words on title of chart in qliksense

Yes I got my answer.. Thank you so much for help.

sheetal1234
New Contributor II

Re: space between 2 words on title of chart in qliksense

Thanks..

Community Browser