9 Replies Latest reply: Oct 27, 2017 5:06 AM by Sheetal Borchate

# 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???

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

Hi Sheetal,

May be like this:

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

Thanks,

Arvind Patil

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

Hi,

But it is not working..

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

Use this in an expression:

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

Chr(160) = Space

• ###### 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.

• ###### 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

• ###### 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