Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

Line break text display in Qliksense table

Hi - I have the text as below.

 

Key Accomplishment

1.ABC

2.DEF

3.GHI

 

but when it is loaded it shows as below.

Key Accomplishment 1.ABC.  2.DEF 3.GHI

 

How can I display  with 1.2.3 like the original text ?

Labels (2)
1 Solution

Accepted Solutions
ChannaK
Creator
Creator

load * inline [Key. Accomplishment

1.ABC

2.DEF

3.GHI] (delimiter is '.');

View solution in original post

3 Replies
Qrishna
Master
Master

you need Chr(10)  for a line break. do this:

Load Rowno() as Dim,
       '1. ABC' & Chr(10) & '2. DEF' & Chr(10) & '3. GHI' as meas
AutoGenerate 1;

 

2487422 - Line break text display in Qliksense table (1).PNG

 

ChannaK
Creator
Creator

load * inline [Key. Accomplishment

1.ABC

2.DEF

3.GHI] (delimiter is '.');

anat
Master
Master

As @ChannaK  said, you have to use delimiter is '. ' in your load script