topic Re: Text file alignment in QlikView

Text file alignment

Wed, 29 Mar 2017 03:02:56 GMT

I am trying to load a text file in my qvw,the contents are well aligned in text file but when I see in qvw it's not showing aligned,how to do that

Re: Text file alignment

hector_munoz — Wed, 29 Mar 2017 03:08:50 GMT

Hi Shivali,

Could you attach a sample of the file?

Regards,

Re: Text file alignment

sushil353 — Wed, 29 Mar 2017 03:13:25 GMT

Hi,

While loading the text file check and try different option for Delimiter and Character set option. If that doesn't work then share a sample file for better resolution.

HTH

Sushil

Re: Text file alignment

rahulpawarb — Wed, 29 Mar 2017 04:03:55 GMT

Hello Shivali,

Trust that you are doing well!

You can achieve the layout changes by referring below steps:

1. Open the properties window of respective chart object

2. Go to the Presentation Tab

3. Select the desired field and set the alignment options as per your need (Alignment Options as for Labels, Text & Numbers; If particular field is alphanumeric then set the alignment for Text as well as Numbers)

Hope this will be helpful.

Regards!

Rahul

Re: Text file alignment

jonathandienst — Wed, 29 Mar 2017 05:16:15 GMT

Are leading and/or trailing blanks being stripped of the text? Is the source file indented using spaces or tabs? By default, QV strips leading and trailing white space from text. To prevent this, set this system variable before the problem load statements:

Set Verbatim = 1;

This causes QV to load the white space as part of the text.

Re: Text file alignment

Wed, 29 Mar 2017 07:20:54 GMT

how to attach a text file over here?

Re: Text file alignment

Wed, 29 Mar 2017 07:24:16 GMT

the sample is as below:

this is a kind of content in my text file:

1)dfgdgdgfhgfh 2)vghjhjbjkhkhjkllgjl

fdhhfhfg gfhjhhkhkkkjjghgjg

hgjghjkhkhkhkhhj

bmhbmgkkhjkhkhk ghjgjkkljlkk;kl;lllhjkj

Re: Text file alignment

Wed, 29 Mar 2017 07:29:55 GMT

just to see the content of twxt file on dashboard