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: 
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
Former Employee
Former Employee

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
MVP
MVP

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