<?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: One table different levels of access for the same user in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Section-Access-One-table-different-levels-of-access-for-the-same/m-p/985740#M952179</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Qlik Folks,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A question for all you Section Access gurus out there.&amp;nbsp; I am needing to provide a user, different levels of access to the same data table e.g.:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The table:&lt;/P&gt;&lt;P&gt;EmployeePayFacts: &lt;/P&gt;&lt;P&gt;$ Value&lt;/P&gt;&lt;P&gt;Cost CentreID&lt;/P&gt;&lt;P&gt;EmployeeID&lt;/P&gt;&lt;P&gt;EmployeeManagerID&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The requirements:&lt;/P&gt;&lt;OL style="list-style-type: decimal;"&gt;&lt;LI&gt;A manager may access detail employee level data for their staff&amp;nbsp; only e.g. filter by the EmployeeManagerID&lt;/LI&gt;&lt;LI&gt;A manager may access aggregate&amp;nbsp; Cost Centre level data for&lt;STRONG style="text-decoration: underline;"&gt; all&lt;/STRONG&gt; Cost Centres (regardless of EmployeeManagerID)&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I considered creating two tables one with $ values at an Employee Level, and another at CostCentre level and use Section Access separately for each table. Problem is I would like to avoid the overhead of extra records.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any ideas?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 26 Nov 2015 02:17:06 GMT</pubDate>
    <dc:creator>reanfadyl</dc:creator>
    <dc:date>2015-11-26T02:17:06Z</dc:date>
    <item>
      <title>Section Access: One table different levels of access for the same user</title>
      <link>https://community.qlik.com/t5/QlikView/Section-Access-One-table-different-levels-of-access-for-the-same/m-p/985740#M952179</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Qlik Folks,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;A question for all you Section Access gurus out there.&amp;nbsp; I am needing to provide a user, different levels of access to the same data table e.g.:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The table:&lt;/P&gt;&lt;P&gt;EmployeePayFacts: &lt;/P&gt;&lt;P&gt;$ Value&lt;/P&gt;&lt;P&gt;Cost CentreID&lt;/P&gt;&lt;P&gt;EmployeeID&lt;/P&gt;&lt;P&gt;EmployeeManagerID&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The requirements:&lt;/P&gt;&lt;OL style="list-style-type: decimal;"&gt;&lt;LI&gt;A manager may access detail employee level data for their staff&amp;nbsp; only e.g. filter by the EmployeeManagerID&lt;/LI&gt;&lt;LI&gt;A manager may access aggregate&amp;nbsp; Cost Centre level data for&lt;STRONG style="text-decoration: underline;"&gt; all&lt;/STRONG&gt; Cost Centres (regardless of EmployeeManagerID)&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I considered creating two tables one with $ values at an Employee Level, and another at CostCentre level and use Section Access separately for each table. Problem is I would like to avoid the overhead of extra records.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any ideas?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Nov 2015 02:17:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Section-Access-One-table-different-levels-of-access-for-the-same/m-p/985740#M952179</guid>
      <dc:creator>reanfadyl</dc:creator>
      <dc:date>2015-11-26T02:17:06Z</dc:date>
    </item>
    <item>
      <title>Re: Section Access: One table different levels of access for the same user</title>
      <link>https://community.qlik.com/t5/QlikView/Section-Access-One-table-different-levels-of-access-for-the-same/m-p/985741#M952180</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You can't apply different section access rules to different fields of the same record of the same table. You'll have to create another table.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 26 Nov 2015 07:10:33 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Section-Access-One-table-different-levels-of-access-for-the-same/m-p/985741#M952180</guid>
      <dc:creator>Gysbert_Wassenaar</dc:creator>
      <dc:date>2015-11-26T07:10:33Z</dc:date>
    </item>
  </channel>
</rss>

