<?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 Problem with totals to hide records in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251754#M95473</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;DIV class="almost_half_cell" id="gt-res-content"&gt;&lt;DIV dir="ltr" style="zoom: 1;"&gt;&lt;SPAN id="result_box" lang="en" style="font-size: 16px; color: #333333; min-height: 93px; display: block; padding: 8px;"&gt;&lt;SPAN class="hps"&gt;Thanks&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Miguel,&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;so&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;it clears.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN class="hps"&gt;However I have&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;a&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;pivot table&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;in which&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;I intend to&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;do the same&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;but I&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;options&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;are&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;disabled&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;and I can not&lt;/SPAN&gt; &lt;SPAN class="hps atn"&gt;change to "&lt;/SPAN&gt;Mode &lt;SPAN class="hps"&gt;Total:&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Sum of&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Rows&lt;/SPAN&gt;" &lt;SPAN class="hps"&gt;is because&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;you&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;can be?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class="hps"&gt;Regards,&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Daniel&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P id="gt-res-tools"&gt;&lt;/P&gt;&lt;DIV id="gt-res-tools-r" style="float: right;"&gt;&lt;DIV id="gt-res-rate" style="float: left;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button" style="position: relative; display: inline-block; border-top-left-radius: 2px; border-top-right-radius: 2px; border-bottom-right-radius: 2px; border-bottom-left-radius: 2px; background-color: initial; outline-style: none; height: 24px; color: #444444; line-height: 24px; font-size: 11px; font-weight: bold; vertical-align: middle; cursor: default; background-position: 0px 50%; border-width: 1px; border-color: transparent; border-style: solid;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button-outer-box" style="position: relative; display: inline-block;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button-inner-box" style="position: relative; display: inline-block; vertical-align: top; padding-right: 2px; padding-left: 2px;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button-caption" style="position: relative; display: inline-block;"&gt;&lt;SPAN class="goog-flat-menu-button-img gt-rate-icon jfk-button-img" style="width: 21px; height: 21px; display: inline-block; background-color: initial; opacity: 0.667; margin-top: -3px; vertical-align: middle; background-position: no-repeat no-repeat;"&gt; &lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 04 Jan 2012 18:09:47 GMT</pubDate>
    <dc:creator />
    <dc:date>2012-01-04T18:09:47Z</dc:date>
    <item>
      <title>Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251752#M95471</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;Hello,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;BR style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;In the document&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;attached as&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;I can&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;do to make&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;me&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;correctly&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;calculate&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;total&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;pivot table&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;.&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;He&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;is taking&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;intoaccount&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;the&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;record that&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;I have withheld&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;making the entire&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;line&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;return&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;null values&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;​​to be&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;suppressed.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;BR style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;Regards,&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;Daniel&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 17:41:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251752#M95471</guid>
      <dc:creator />
      <dc:date>2012-01-04T17:41:17Z</dc:date>
    </item>
    <item>
      <title>Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251753#M95472</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Daniel,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;That happens when you use a conditional instead of an aggregation expresion, because it has to compare row by row. Go to the chart properties, Expressions tab and click the "Sum of Rows" in "Total Mode", that will return the totals as expected.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope that helps.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Miguel&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 17:53:22 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251753#M95472</guid>
      <dc:creator>Miguel_Angel_Baeyens</dc:creator>
      <dc:date>2012-01-04T17:53:22Z</dc:date>
    </item>
    <item>
      <title>Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251754#M95473</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;DIV class="almost_half_cell" id="gt-res-content"&gt;&lt;DIV dir="ltr" style="zoom: 1;"&gt;&lt;SPAN id="result_box" lang="en" style="font-size: 16px; color: #333333; min-height: 93px; display: block; padding: 8px;"&gt;&lt;SPAN class="hps"&gt;Thanks&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Miguel,&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;so&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;it clears.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN class="hps"&gt;However I have&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;a&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;pivot table&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;in which&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;I intend to&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;do the same&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;but I&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;options&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;are&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;disabled&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;and I can not&lt;/SPAN&gt; &lt;SPAN class="hps atn"&gt;change to "&lt;/SPAN&gt;Mode &lt;SPAN class="hps"&gt;Total:&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Sum of&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Rows&lt;/SPAN&gt;" &lt;SPAN class="hps"&gt;is because&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;you&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;can be?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class="hps"&gt;Regards,&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;Daniel&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P id="gt-res-tools"&gt;&lt;/P&gt;&lt;DIV id="gt-res-tools-r" style="float: right;"&gt;&lt;DIV id="gt-res-rate" style="float: left;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button" style="position: relative; display: inline-block; border-top-left-radius: 2px; border-top-right-radius: 2px; border-bottom-right-radius: 2px; border-bottom-left-radius: 2px; background-color: initial; outline-style: none; height: 24px; color: #444444; line-height: 24px; font-size: 11px; font-weight: bold; vertical-align: middle; cursor: default; background-position: 0px 50%; border-width: 1px; border-color: transparent; border-style: solid;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button-outer-box" style="position: relative; display: inline-block;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button-inner-box" style="position: relative; display: inline-block; vertical-align: top; padding-right: 2px; padding-left: 2px;"&gt;&lt;DIV class="goog-inline-block goog-toolbar-menu-button-caption" style="position: relative; display: inline-block;"&gt;&lt;SPAN class="goog-flat-menu-button-img gt-rate-icon jfk-button-img" style="width: 21px; height: 21px; display: inline-block; background-color: initial; opacity: 0.667; margin-top: -3px; vertical-align: middle; background-position: no-repeat no-repeat;"&gt; &lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 18:09:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251754#M95473</guid>
      <dc:creator />
      <dc:date>2012-01-04T18:09:47Z</dc:date>
    </item>
    <item>
      <title>Re: Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251755#M95474</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;This&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;attachment is&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;that&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;my other&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;case that&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;will not let me&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;change.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;A&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;greeting.&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 18:18:26 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251755#M95474</guid>
      <dc:creator />
      <dc:date>2012-01-04T18:18:26Z</dc:date>
    </item>
    <item>
      <title>Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251756#M95475</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Daniel, &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;As discussed, pivot tables don't allow that Total Mode:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A class="jive-link-external-small" href="http://community.qlik.com/message/176627#176627"&gt;http://community.qlik.com/message/176627#176627&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Miguel&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 18:27:43 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251756#M95475</guid>
      <dc:creator>Miguel_Angel_Baeyens</dc:creator>
      <dc:date>2012-01-04T18:27:43Z</dc:date>
    </item>
    <item>
      <title>Re: Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251757#M95476</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Though you may use AGGR() functions to make an expression that´s behave like the "sum of rows" available in Straight Table.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 19:10:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251757#M95476</guid>
      <dc:creator>fernandotoledo</dc:creator>
      <dc:date>2012-01-04T19:10:17Z</dc:date>
    </item>
    <item>
      <title>Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251758#M95477</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;DIV dir="ltr" style="zoom: 1;"&gt;&lt;SPAN id="result_box" lang="en" style="font-size: 16px; color: #333333; min-height: 93px; display: block; padding: 8px;"&gt;&lt;SPAN class="hps"&gt;Can&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;I use&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;the function&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;aggr&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;() in a&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;pivot table&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;for what I&lt;/SPAN&gt;&lt;SPAN&gt;'m trying to do&lt;/SPAN&gt;&lt;SPAN&gt;?&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;And&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;the expression&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;is made&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 19:19:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251758#M95477</guid>
      <dc:creator />
      <dc:date>2012-01-04T19:19:06Z</dc:date>
    </item>
    <item>
      <title>Re: Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251759#M95478</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;This file exemplify the use of aggr to simulate an "Sum of Rows" total from a straight table on a pivot table.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Fernando&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 19:52:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251759#M95478</guid>
      <dc:creator>fernandotoledo</dc:creator>
      <dc:date>2012-01-04T19:52:16Z</dc:date>
    </item>
    <item>
      <title>Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251760#M95479</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;I do not understand&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;your example.&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;Added&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;my&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;attachment&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;not&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;good because&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;then I&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;deleted&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;rows that&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;had&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;intoaccount&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;BR style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;Regards,&lt;/SPAN&gt;&lt;SPAN style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt; &lt;/SPAN&gt;&lt;SPAN class="hps" style="font-family: arial, sans-serif; font-size: 16px; text-align: -webkit-auto; background-color: #f5f5f5;"&gt;Daniel&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 04 Jan 2012 20:35:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251760#M95479</guid>
      <dc:creator />
      <dc:date>2012-01-04T20:35:13Z</dc:date>
    </item>
    <item>
      <title>Re: Problem with totals to hide records</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251761#M95480</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I made the changes in your file, see if it´s like you want to.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 05 Jan 2012 17:53:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-with-totals-to-hide-records/m-p/251761#M95480</guid>
      <dc:creator>fernandotoledo</dc:creator>
      <dc:date>2012-01-05T17:53:41Z</dc:date>
    </item>
  </channel>
</rss>

