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

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

Thu, 20 Feb 2014 19:57:53 GMT

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

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

Clever_Anjos — Thu, 20 Feb 2014 20:18:27 GMT

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

Thu, 20 Feb 2014 20:54:17 GMT

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

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

Thu, 20 Feb 2014 20:54:44 GMT

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

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

Anonymous — Thu, 20 Feb 2014 21:00:12 GMT

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

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

Thu, 20 Feb 2014 21:35:57 GMT

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

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

Anonymous — Thu, 20 Feb 2014 21:42:32 GMT

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

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

Thu, 20 Feb 2014 21:54:36 GMT

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?

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

Anonymous — Thu, 20 Feb 2014 22:03:17 GMT

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

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

Anonymous — Thu, 20 Feb 2014 22:17:49 GMT

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.

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

Thu, 20 Feb 2014 22:19:18 GMT

Thanks Michael for your help but it is not possible for me to share my file .

Regards,

Varun