Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

Tags (2)
10 Replies
Employee
Employee

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

Capturar.PNG.png

Not applicable

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

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

Not applicable

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

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

mov
Esteemed Contributor III

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

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

Not applicable

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

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

mov
Esteemed Contributor III

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

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

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

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?

mov
Esteemed Contributor III

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

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

mov
Esteemed Contributor III

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

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.