-
Re: space between 2 words on title of chart in qliksense
Arvind Patil Oct 27, 2017 3:05 AM (in response to Sheetal Borchate)Hi Sheetal,
May be like this:
='P&L '&' '&' Rs. Cr'
Thanks,
Arvind Patil
-
Re: space between 2 words on title of chart in qliksense
Sheetal Borchate Oct 27, 2017 3:23 AM (in response to Arvind Patil)Hi,
Thanks for prompt reply.
I tried your solution.
But it is not working..
-
-
Re: space between 2 words on title of chart in qliksense
Brijesh Fofadiya Oct 27, 2017 3:26 AM (in response to Sheetal Borchate)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
Ralf Heukäufer Oct 27, 2017 3:33 AM (in response to Sheetal Borchate)Hi you can try it with different Characters like:
='P&L '& chr(9) &' Rs. Cr'
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
Simon Minifie Oct 27, 2017 3:46 AM (in response to Sheetal Borchate)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
Bazil Momin Oct 27, 2017 4:44 AM (in response to Sheetal Borchate)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
-
Re: space between 2 words on title of chart in qliksense
omar bensalem Oct 27, 2017 4:55 AM (in response to Bazil Momin )You can close the thread; here's your answer !
-
Re: space between 2 words on title of chart in qliksense
Sheetal Borchate Oct 27, 2017 5:07 AM (in response to Bazil Momin )Thanks..
-
-
Re: space between 2 words on title of chart in qliksense
Sheetal Borchate Oct 27, 2017 5:06 AM (in response to Sheetal Borchate)Yes I got my answer.. Thank you so much for help.