<?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 Displaying value of variable - dynamically in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Displaying-value-of-variable-dynamically/m-p/1260106#M397565</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Morning - couple of questions&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.&amp;nbsp; Is it possible to setup the value of a variable at the SHEET level - I.E I have about 9 displays on the sheet and have 6 such sheets, each of which corresponds to a specific domain, and can be determined from the value of a variable.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2.&amp;nbsp; I also want to be able to display the value of this variable, as part of the 9 displays (graph, chart etc.,) - say in the title or as a water mark.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here's what I do currently in each of the 9 displays within on a sheet and it works&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;=&lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Sum&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;({$&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;PoolName&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;={&lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;"COCP"&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;}&amp;gt;} &lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;[Total WO]&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;) &lt;/SPAN&gt; - I want to know if this can be done at the sheet, and therefore each of the displays inherit this property.&lt;/P&gt;&lt;P&gt;then I want to display this value in the title along with two other dimensions - here's what I have for the title -&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;='By'&amp;amp;' '&amp;amp;&lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;GetObjectField&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;(0)&amp;amp;', '&amp;amp;&lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;GetObjectField&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;(1) &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;Thx&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;Raj&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 16 Nov 2016 13:31:56 GMT</pubDate>
    <dc:creator>Rkota</dc:creator>
    <dc:date>2016-11-16T13:31:56Z</dc:date>
    <item>
      <title>Displaying value of variable - dynamically</title>
      <link>https://community.qlik.com/t5/QlikView/Displaying-value-of-variable-dynamically/m-p/1260106#M397565</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Morning - couple of questions&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.&amp;nbsp; Is it possible to setup the value of a variable at the SHEET level - I.E I have about 9 displays on the sheet and have 6 such sheets, each of which corresponds to a specific domain, and can be determined from the value of a variable.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2.&amp;nbsp; I also want to be able to display the value of this variable, as part of the 9 displays (graph, chart etc.,) - say in the title or as a water mark.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Here's what I do currently in each of the 9 displays within on a sheet and it works&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;=&lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Sum&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;({$&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;PoolName&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;={&lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;"COCP"&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;}&amp;gt;} &lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;[Total WO]&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;) &lt;/SPAN&gt; - I want to know if this can be done at the sheet, and therefore each of the displays inherit this property.&lt;/P&gt;&lt;P&gt;then I want to display this value in the title along with two other dimensions - here's what I have for the title -&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;='By'&amp;amp;' '&amp;amp;&lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;GetObjectField&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;(0)&amp;amp;', '&amp;amp;&lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;GetObjectField&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;(1) &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;Thx&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 8pt;"&gt;Raj&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 16 Nov 2016 13:31:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Displaying-value-of-variable-dynamically/m-p/1260106#M397565</guid>
      <dc:creator>Rkota</dc:creator>
      <dc:date>2016-11-16T13:31:56Z</dc:date>
    </item>
  </channel>
</rss>

