inserting a line break in field values ********in Qliksense not in Qlikview*********

[prutis66]

Hi ,

i have dimension values say abcdef. I need if length is more than 3, than it must appear in new line.

like: abc

          def

[mrybalko]

Hello, @prutis66 

Try this code:

=if(len(ObjectID) >=3, left(ObjectID, 3) & chr(10) & mid(ObjectID, 4), ObjectID)

I suggest to make new field on data loading stage

[prutis66]

Hi Thanks for your response but i am using qliksense and is not working in it

[mrybalko]

[prutis66]

---

@mrybalko wrote:

---

[prutis66]

Hi , it is showing as space and not as new line. i am using qliksense desktop. should i have to set any line break in initial declaration section?