topic Trying to display text from Excel file based on selection in App Development https://community.qlik.com/t5/App-Development/Trying-to-display-text-from-Excel-file-based-on-selection/m-p/980336#M14200 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to use existing visualizations to display text in one column on an excel table if it exists based on the selection from another column.&nbsp; Not all rows in the first column have text in the second one, but if it does and it is selected, I want it to display the full text.&nbsp; Currently I am trying to use the Text and Image visualization, but I have my string field plugged in as a measure and have no aggregation on it so that it displays the text.&nbsp; This almost works (the information I am trying to have display is an SQL query) except that the comments, written as /* and */ seem to trigger the visualization to display "x000D" instead of the comment.&nbsp; How can I make this display the comment instead?&nbsp; Does anyone know why it is changing it?</P><P></P><P>If there is a better way to do what I am trying to do please let me know.&nbsp; I tried using just a table and having the second column be the only one and removing null values so only available text would display, however it is truncated and I am not able to make it display the full text.</P><P></P><P>Thank you for any help</P></BODY></HTML> Wed, 23 Dec 2015 16:55:16 GMT 2015-12-23T16:55:16Z Trying to display text from Excel file based on selection https://community.qlik.com/t5/App-Development/Trying-to-display-text-from-Excel-file-based-on-selection/m-p/980336#M14200 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to use existing visualizations to display text in one column on an excel table if it exists based on the selection from another column.&nbsp; Not all rows in the first column have text in the second one, but if it does and it is selected, I want it to display the full text.&nbsp; Currently I am trying to use the Text and Image visualization, but I have my string field plugged in as a measure and have no aggregation on it so that it displays the text.&nbsp; This almost works (the information I am trying to have display is an SQL query) except that the comments, written as /* and */ seem to trigger the visualization to display "x000D" instead of the comment.&nbsp; How can I make this display the comment instead?&nbsp; Does anyone know why it is changing it?</P><P></P><P>If there is a better way to do what I am trying to do please let me know.&nbsp; I tried using just a table and having the second column be the only one and removing null values so only available text would display, however it is truncated and I am not able to make it display the full text.</P><P></P><P>Thank you for any help</P></BODY></HTML> Wed, 23 Dec 2015 16:55:16 GMT https://community.qlik.com/t5/App-Development/Trying-to-display-text-from-Excel-file-based-on-selection/m-p/980336#M14200 2015-12-23T16:55:16Z