<?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 chart problem in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/chart-problem/m-p/217771#M70954</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi&lt;/P&gt;&lt;P&gt;this is my problem:&lt;/P&gt;&lt;P&gt;i have a chart and i have to represent a value that is not in the cloud. it is external.&lt;/P&gt;&lt;P&gt;i find a solution using an expression and the " if " , but i would like to use a set analysis if it is possibile.&lt;/P&gt;&lt;P&gt;someone can help me?&lt;/P&gt;&lt;P&gt;i attach an example, my solution , very simple. i have the element year2 that is external and i use as dimension.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 15 Apr 2011 11:25:39 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2011-04-15T11:25:39Z</dc:date>
    <item>
      <title>chart problem</title>
      <link>https://community.qlik.com/t5/QlikView/chart-problem/m-p/217771#M70954</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi&lt;/P&gt;&lt;P&gt;this is my problem:&lt;/P&gt;&lt;P&gt;i have a chart and i have to represent a value that is not in the cloud. it is external.&lt;/P&gt;&lt;P&gt;i find a solution using an expression and the " if " , but i would like to use a set analysis if it is possibile.&lt;/P&gt;&lt;P&gt;someone can help me?&lt;/P&gt;&lt;P&gt;i attach an example, my solution , very simple. i have the element year2 that is external and i use as dimension.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 15 Apr 2011 11:25:39 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/chart-problem/m-p/217771#M70954</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2011-04-15T11:25:39Z</dc:date>
    </item>
    <item>
      <title>chart problem</title>
      <link>https://community.qlik.com/t5/QlikView/chart-problem/m-p/217772#M70955</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Alberto,&lt;/P&gt;&lt;P&gt;Actually, your IF is not working properly either. Here is the correct information:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE bgcolor="white" border="1" cellpadding="0" cellspacing="0" style="FONT-SIZE:9pt;"&gt;&lt;TBODY&gt;&lt;TR align="left"&gt;&lt;TH&gt;&lt;B&gt;year2&lt;/B&gt; &lt;B&gt;&lt;/B&gt;&lt;/TH&gt;&lt;TH&gt;&lt;B&gt;sum(price)&lt;/B&gt; &lt;B&gt;&lt;/B&gt;&lt;/TH&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="#F5F5F5"&gt;&lt;/TD&gt;&lt;TD bgcolor="#F5F5F5"&gt;&lt;B&gt;127&lt;/B&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="white"&gt;2005&lt;/TD&gt;&lt;TD bgcolor="white"&gt;127&lt;/TD&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="white"&gt;2006&lt;/TD&gt;&lt;TD bgcolor="white"&gt;127&lt;/TD&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="white"&gt;2007&lt;/TD&gt;&lt;TD bgcolor="white"&gt;127&lt;/TD&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="white"&gt;2008&lt;/TD&gt;&lt;TD bgcolor="white"&gt;127&lt;/TD&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="white"&gt;2009&lt;/TD&gt;&lt;TD bgcolor="white"&gt;127&lt;/TD&gt;&lt;/TR&gt;&lt;TR align="right"&gt;&lt;TD bgcolor="white"&gt;2010&lt;/TD&gt;&lt;TD bgcolor="white"&gt;127&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR /&gt;&lt;BR /&gt; &lt;P&gt;The set analysis expression would be: sum({&amp;lt;year2=P(year)&amp;gt;}price) which does produce the correct results (a flat line over 2 of the years).&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 15 Apr 2011 23:50:53 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/chart-problem/m-p/217772#M70955</guid>
      <dc:creator>vgutkovsky</dc:creator>
      <dc:date>2011-04-15T23:50:53Z</dc:date>
    </item>
  </channel>
</rss>

