Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
Hi Sheetal,
May be like this:
='P&L '&' '&' Rs. Cr'
Thanks,
Arvind Patil
Hi,
Thanks for prompt reply.
I tried your solution.
But it is not working..
Hi sheetal1234
Use this in an expression:
='P&L' & Chr(160) & Chr(160) & Chr(160) & ' Rs. Cr'
Chr(160) = Space
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.
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
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
You can close the thread; here's your answer !
Yes I got my answer.. Thank you so much for help.
Thanks..