4 Replies Latest reply: Mar 14, 2016 12:50 PM by Saran De RSS

    Display Long Text

    Mehdi Akbarpour

      Hi guys I want to know if there is any solutions to display files including long texts in QlikView?

      Let me explain more details about my situation. I have a lot of emails in my outlook which I converted to MS Access and imported to QlikView. But some of them are too long.

        • Re: Display Long Text
          Marcus Sommer

          How long is too long (how many chars)? How did you try to display these data?

           

          - Marcus

          • Re: Display Long Text
            Peter Cammaert

            Not really no.

             

            Displaying very long texts in a text box or a table cell will not cause QlikView to display a vertical scroll bar, unfortunately. However, it the text string doesn't fit in the available space, QlikView will try to display all text in a tooltip-like temporary window if you hover your mouse pointer over the cell. Of course, this technique also has its limitations.

             

            Why do you want to move your email messages to QlikView?

             

            Peter

            • Re: Display Long Text
              Gysbert Wassenaar

              Well, Qlikview is a BI tool, not an email program or a text editor. You can try using a text box that will display the contents of the field with lost of text. Let the user select a email and use the text box to show the details of the selected email. The text box can have scroll bars if you like.

              • Re: Display Long Text
                Saran De

                Also, you have to replace some of the characters to avoid unexpected result.

                 

                For instance, if your text has '\n', it will act as new-line and place the remaining text in the next line.

                 

                Your Text:

                \\nabcdef\ghijk

                 

                Output:

                \

                abcdef\ghijk