Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to align Text in Input box importing from external source?

Hi All,

I have a question on how to left align the text in input box when importing directly from external source? As of now the text is appearing in the form of paragraph but want to present it in line breaks? I don't see any option in Input box properties for alignment?

Thanks,

Varun

10 Replies
Clever_Anjos
Employee
Employee

Capturar.PNG.png

Not applicable
Author

Thanks Anjos but Can we apply something similar in Text box also?

Not applicable
Author

Thanks Anjos but Can we apply something similar in Text box also?

Anonymous
Not applicable
Author

Yes, it looks differently - see tab General, section Layout (in the middle) - Horizontal and Vertical alignments

Not applicable
Author

Thanks Michael.But still not able to do line break.

Current Output: 1.aaaaaaaaaaaaaaaaaa 2.bbbbbbbbbbbbbbbbbb 3.cccccccccccccccccc

Desired Output : 1.aaaaaaaaaaaaaaaaa

                         2.bbbbbbbbbbbbbbbbb

                         3.ccccccccccccccccc

How to achieve desired output in text box?

Regards,

Varun

Anonymous
Not applicable
Author

Breaks can be inserted using chr(10), for example:

='1.aaaaaaaaaaaaaaaaaa' & chr(10) & '2.bbbbbbbbbbbbbbbbbb' & chr(10) & '3.cccccccccccccccccc'

In this case it is essential to use "=" at the beginning.

Regards,

Michael

Not applicable
Author

Michael,This will help only when we are inputing text from our end but here we are exporting text directly to text box from external source.The question is can we modify the already exported text or not?

Anonymous
Not applicable
Author

It should be possible.  You have to replace "line feeds" in the original text with the chr(10) or chr(13) on reload.

(I'm pretty much sure I've done it, but it's been awhile).

If you upload an example of your data (text file?), I can give it a try tomorrow.  Or somebody else will while I'm away...

Anonymous
Not applicable
Author

Some follow-up:
I found my old app, and can tell that there was no need to anything special in my case.  Loaded email bodies from SQL database, all formatting preserved.

Need and example of your app with the data source.