How to display content of a text file or word doc in QlikView

[sudeepkm]

Hi All,

I need help in showing the contents of a text file or a word doc in QlikView.

Please see if anyone can throw some idea here.

Regards,

Sudeep

[#2]

Do you want to count each words and display some statistics ?

If yes, look at he example create by Martha Hernandez

http://community.qlik.com/qlikviews/1045#comment-1408

She reads a text with inline, then create "words" with this expression

mapsubstring('TextMap',subfield(capitalize(keepchar(upper(Text),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ')),' ')) as Word

JJ

[sudeepkm]

Thanks a  lot . Actually i've a text file like below.

I want to read that file contents in QlikView and i want to display the content in a Text Object in QlikView.

When i tried loading the file i got the file contents in a list box each line as a row in the list box along with speacial charactors. Is there a way to display them in a Text Object in Qlikview?

[Anonymous]

I am not sure if that is possible.
Isn't it an option to save your textfile as .bmp or .jpg?

That way you can use it in any text object (Background image)

[sudeepkm]

Initially i thought of creating an image file but the problem is, this text file is going to change every month and the no. of lines also be changed. In case the text file has scroll bar then it cant be accessed if i use the image of the file.

[deepti_singh]

Hi Sudeep,

I am looking for a similar requirement but in Qlik Sense. Did you find any solution?

Thanks.

Deepti

[vsabbise]

I think the best way is to read the file using Python and write it to a csv/excel with 2 columns. 1) filename 2) fileText . 

Import the csv/excel into Qlik Sense and display the text.