<?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 indicators in pivot table in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/using-indicators-in-pivot-table/m-p/366647#M136384</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear&lt;/P&gt;&lt;P&gt;I got a chart (pivot table) with Country, Brand Group as Dimensions&lt;/P&gt;&lt;P&gt;I'm calculating the sales variance&lt;/P&gt;&lt;P&gt;Now by Country I may get value that is positive but if I expand the country and see the values by brand groups, some brand groups may have negative values&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now if the user collapses this country that has brand groups with negative values I want to show an image in an expression indicating a warning whereas if the country that is collapsed has all values by brand groups positive then display another image&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How can we do this?&lt;/P&gt;&lt;P&gt;Please advise&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 24 May 2012 08:04:24 GMT</pubDate>
    <dc:creator>ali_hijazi</dc:creator>
    <dc:date>2012-05-24T08:04:24Z</dc:date>
    <item>
      <title>using indicators in pivot table</title>
      <link>https://community.qlik.com/t5/QlikView/using-indicators-in-pivot-table/m-p/366647#M136384</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear&lt;/P&gt;&lt;P&gt;I got a chart (pivot table) with Country, Brand Group as Dimensions&lt;/P&gt;&lt;P&gt;I'm calculating the sales variance&lt;/P&gt;&lt;P&gt;Now by Country I may get value that is positive but if I expand the country and see the values by brand groups, some brand groups may have negative values&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now if the user collapses this country that has brand groups with negative values I want to show an image in an expression indicating a warning whereas if the country that is collapsed has all values by brand groups positive then display another image&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How can we do this?&lt;/P&gt;&lt;P&gt;Please advise&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 24 May 2012 08:04:24 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/using-indicators-in-pivot-table/m-p/366647#M136384</guid>
      <dc:creator>ali_hijazi</dc:creator>
      <dc:date>2012-05-24T08:04:24Z</dc:date>
    </item>
  </channel>
</rss>

