Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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

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

Labels (3)
5 Replies
Highlighted
Creator II
Creator II

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

Highlighted
Contributor II
Contributor II

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

line break.JPG

Highlighted
Contributor II
Contributor II

line break.PNG


@mrybalko wrote:

line break.JPG


 

Highlighted
Contributor II
Contributor II

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?