Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
srujanaponnuru
Creator
Creator

Breaking string into next line in a text object from inline load

Hi ,

i have inline load as below:

Load * Inline [
Column

1. What is Operations? 2. What is visualization ? 3. What is Design?

];

but i am getting output in frontend as below:

srujanaponnuru_0-1648994246633.png

i need to show one by one in a text object in front end. 

in text object i took the direct field as Column. 

 

i tried using subfield but it didnt work. please assist me

Labels (1)
4 Replies
Sweta_Sharma
Support
Support

Hi @srujanaponnuru ,

Please try below script-
Load * Inline [
Column

1. What is Operations? 
2. What is visualization ? 
3. What is Design?

];

Cheers!

If the issue is solved please mark the answer with Accept as Solution
srujanaponnuru
Creator
Creator
Author

@SWETHA as i have used only function in frontend expression, if i write inline table as you have mentioned, i am not getting all the questions to text object. 

=
if($(vButton)=1,only(Column)) 

srujanaponnuru
Creator
Creator
Author

Hi All,

i have used replace n my inline load as below

Data:
Load
Replace(Column,' ',chr(10));
Load * Inline [
Column
1.What is Operations? 2. What is Visualization ? 3. What is Design ?

];

 

Now my output is showing as 

srujanaponnuru_0-1648997074001.png

please assist in making one line. 

MarcoWedel

Can you specify a general rule to identify the positions where you want to insert a line break?