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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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