<?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 Section Access with three Reduction field not working properly. in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Section-Access-with-three-Reduction-field-not-working-properly/m-p/398746#M148425</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; I need to design a security where the reduction is based on three fields.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Some combination of security tables are like FIELD1 = 'XYZ', FIELD2 = *, FIELD3 = *.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Now the section access I designed works perfectly if it is an admin user with all the three fields * or it works fine with USERS where all the three FIELDS 1,2,3 contains value but &lt;STRONG&gt;doesn't work in situations like one field contains value and other as *&lt;/STRONG&gt;. Sometimes it gives error Failed to Load or sometimes open with all the data.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have used all &lt;STRONG&gt;UPPER Cases all over &lt;/STRONG&gt;, &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; also used &lt;STRONG&gt;Star as *&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; also &lt;STRONG&gt;Reduce data based on section access is checked&lt;/STRONG&gt;, &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Also &lt;STRONG&gt;Strict Exclusion is unckecked&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please suggest what should I do?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Amar&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 03 Dec 2012 07:56:11 GMT</pubDate>
    <dc:creator>amars</dc:creator>
    <dc:date>2012-12-03T07:56:11Z</dc:date>
    <item>
      <title>Section Access with three Reduction field not working properly.</title>
      <link>https://community.qlik.com/t5/QlikView/Section-Access-with-three-Reduction-field-not-working-properly/m-p/398746#M148425</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; I need to design a security where the reduction is based on three fields.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Some combination of security tables are like FIELD1 = 'XYZ', FIELD2 = *, FIELD3 = *.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Now the section access I designed works perfectly if it is an admin user with all the three fields * or it works fine with USERS where all the three FIELDS 1,2,3 contains value but &lt;STRONG&gt;doesn't work in situations like one field contains value and other as *&lt;/STRONG&gt;. Sometimes it gives error Failed to Load or sometimes open with all the data.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have used all &lt;STRONG&gt;UPPER Cases all over &lt;/STRONG&gt;, &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; also used &lt;STRONG&gt;Star as *&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; also &lt;STRONG&gt;Reduce data based on section access is checked&lt;/STRONG&gt;, &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Also &lt;STRONG&gt;Strict Exclusion is unckecked&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please suggest what should I do?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Amar&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 03 Dec 2012 07:56:11 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Section-Access-with-three-Reduction-field-not-working-properly/m-p/398746#M148425</guid>
      <dc:creator>amars</dc:creator>
      <dc:date>2012-12-03T07:56:11Z</dc:date>
    </item>
  </channel>
</rss>

