<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Using Expression in Text Object in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Using-Expression-in-Text-Object/m-p/259702#M1189765</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&amp;nbsp; Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need a help regarding display of data in "text object" using expression.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have the below data as a table box in Qlikview.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 800px;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD class="xl24" height="17" width="134"&gt;&lt;STRONG&gt;Country&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl24" style="border-left: medium none;" width="394"&gt;&lt;STRONG&gt;Customer Name&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl24" style="border-left: medium none;" width="145"&gt;&lt;STRONG&gt;Address&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl24" style="border-left: medium none;" width="127"&gt;&lt;STRONG&gt;Product&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;India&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Hritik Roshan&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;12,Broad Street,Mumbai&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Credit Card&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;China&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Cherry k Chen&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;44,Green Park, Bejing&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Personal Loan&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;Hong Kong&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Anthony O&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;65,Park Place,Hong Kong&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Mortgage&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;Australia&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Robert Methews&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;55,Rose Garden, Sydney&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Mutual Fund&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;BR /&gt;I want to display the Customer Name , Address and Product in three different Text Box which would be linked to the above "Table box". For example if i click on a particular customer name in the "table Box" , &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.the same customer name with appear in a text box&lt;/P&gt;&lt;P&gt;2.The corrosponding address of the selected customer will appear in a separate text box&lt;/P&gt;&lt;P&gt;3. The corrosponding product name will appear in the third text box.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I want the data to appear on dynamic basis.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I know that I need to write some expression in the text boxes to make it happen. Now I am confused and unable to write the correct expression.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If anyone can help..!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cheers&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Paul&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 14 Sep 2011 06:25:51 GMT</pubDate>
    <dc:creator />
    <dc:date>2011-09-14T06:25:51Z</dc:date>
    <item>
      <title>Using Expression in Text Object</title>
      <link>https://community.qlik.com/t5/QlikView/Using-Expression-in-Text-Object/m-p/259702#M1189765</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&amp;nbsp; Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need a help regarding display of data in "text object" using expression.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have the below data as a table box in Qlikview.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 800px;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD class="xl24" height="17" width="134"&gt;&lt;STRONG&gt;Country&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl24" style="border-left: medium none;" width="394"&gt;&lt;STRONG&gt;Customer Name&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl24" style="border-left: medium none;" width="145"&gt;&lt;STRONG&gt;Address&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD class="xl24" style="border-left: medium none;" width="127"&gt;&lt;STRONG&gt;Product&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;India&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Hritik Roshan&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;12,Broad Street,Mumbai&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Credit Card&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;China&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Cherry k Chen&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;44,Green Park, Bejing&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Personal Loan&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;Hong Kong&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Anthony O&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;65,Park Place,Hong Kong&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Mortgage&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl25" height="17" style="border-top: medium none;"&gt;Australia&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Robert Methews&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;55,Rose Garden, Sydney&lt;/TD&gt;&lt;TD class="xl25" style="border-top: medium none; border-left: medium none;"&gt;Mutual Fund&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;BR /&gt;I want to display the Customer Name , Address and Product in three different Text Box which would be linked to the above "Table box". For example if i click on a particular customer name in the "table Box" , &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.the same customer name with appear in a text box&lt;/P&gt;&lt;P&gt;2.The corrosponding address of the selected customer will appear in a separate text box&lt;/P&gt;&lt;P&gt;3. The corrosponding product name will appear in the third text box.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I want the data to appear on dynamic basis.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I know that I need to write some expression in the text boxes to make it happen. Now I am confused and unable to write the correct expression.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If anyone can help..!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cheers&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Paul&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 14 Sep 2011 06:25:51 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Using-Expression-in-Text-Object/m-p/259702#M1189765</guid>
      <dc:creator />
      <dc:date>2011-09-14T06:25:51Z</dc:date>
    </item>
  </channel>
</rss>

