<?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 availability of illicit values (Section access) in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/availability-of-illicit-values-Section-access/m-p/527168#M1301849</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello&lt;/P&gt;&lt;DIV dir="ltr"&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;I want to&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;limit the visibility of&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;sales channels,&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;only&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;channel&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;with&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;ID&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;6886711.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P&gt;&lt;SPAN class="short_text" lang="en"&gt;&lt;SPAN class="hps"&gt;here's&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;a&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;code:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Section Access;&lt;/P&gt;&lt;P&gt;LOAD *&lt;/P&gt;&lt;P&gt;FROM&lt;/P&gt;&lt;P&gt;[..\Works\Access.xls]&lt;/P&gt;&lt;P&gt;(biff, embedded labels, table is [Access$]);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Section Application;&lt;/P&gt;&lt;P&gt;CHS:&lt;/P&gt;&lt;P&gt;LOAD CHANNEL_SALE_ID, &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; CHANNEL_SALE&lt;/P&gt;&lt;P&gt;FROM&lt;/P&gt;&lt;P&gt;[..\Works\CHANELS.xls]&lt;/P&gt;&lt;P&gt;(biff, embedded labels, table is [Sheet1$]);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;here is my Access.xls:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48160_pastedImage_4.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;here is my CHANELS.XLS&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48170_pastedImage_6.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;When I open&lt;/SPAN&gt; &lt;/SPAN&gt;33.qvw &lt;SPAN lang="en"&gt;, I can see &lt;SPAN class="hps"&gt;the filter&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;under the terms&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;of the&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;"Section Access",&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;everything is fine&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;...&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48171_pastedImage_8.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;P class="almost_half_cell"&gt;&lt;/P&gt;&lt;DIV dir="ltr"&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;but... WHY&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;user&lt;/SPAN&gt; "trish" &lt;/SPAN&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;can remove&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;this limitation and&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;to view the entire&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;list of values&lt;/SPAN&gt;&lt;SPAN&gt;​​?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48172_pastedImage_9.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 26 Jan 2026 18:19:17 GMT</pubDate>
    <dc:creator />
    <dc:date>2026-01-26T18:19:17Z</dc:date>
    <item>
      <title>availability of illicit values (Section access)</title>
      <link>https://community.qlik.com/t5/QlikView/availability-of-illicit-values-Section-access/m-p/527168#M1301849</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello&lt;/P&gt;&lt;DIV dir="ltr"&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;I want to&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;limit the visibility of&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;sales channels,&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;only&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;channel&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;with&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;ID&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;6886711.&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P&gt;&lt;SPAN class="short_text" lang="en"&gt;&lt;SPAN class="hps"&gt;here's&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;a&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;code:&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Section Access;&lt;/P&gt;&lt;P&gt;LOAD *&lt;/P&gt;&lt;P&gt;FROM&lt;/P&gt;&lt;P&gt;[..\Works\Access.xls]&lt;/P&gt;&lt;P&gt;(biff, embedded labels, table is [Access$]);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Section Application;&lt;/P&gt;&lt;P&gt;CHS:&lt;/P&gt;&lt;P&gt;LOAD CHANNEL_SALE_ID, &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; CHANNEL_SALE&lt;/P&gt;&lt;P&gt;FROM&lt;/P&gt;&lt;P&gt;[..\Works\CHANELS.xls]&lt;/P&gt;&lt;P&gt;(biff, embedded labels, table is [Sheet1$]);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;here is my Access.xls:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48160_pastedImage_4.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;here is my CHANELS.XLS&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48170_pastedImage_6.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;When I open&lt;/SPAN&gt; &lt;/SPAN&gt;33.qvw &lt;SPAN lang="en"&gt;, I can see &lt;SPAN class="hps"&gt;the filter&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;under the terms&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;of the&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;"Section Access",&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;everything is fine&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;...&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48171_pastedImage_8.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;P class="almost_half_cell"&gt;&lt;/P&gt;&lt;DIV dir="ltr"&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;but... WHY&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;user&lt;/SPAN&gt; "trish" &lt;/SPAN&gt;&lt;SPAN lang="en"&gt;&lt;SPAN class="hps"&gt;can remove&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;this limitation and&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;to view the entire&lt;/SPAN&gt; &lt;SPAN class="hps"&gt;list of values&lt;/SPAN&gt;&lt;SPAN&gt;​​?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;P&gt;&lt;IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48172_pastedImage_9.png" style="width: auto; height: auto;" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jan 2026 18:19:17 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/availability-of-illicit-values-Section-access/m-p/527168#M1301849</guid>
      <dc:creator />
      <dc:date>2026-01-26T18:19:17Z</dc:date>
    </item>
    <item>
      <title>Re: availability of illicit values (Section access)</title>
      <link>https://community.qlik.com/t5/QlikView/availability-of-illicit-values-Section-access/m-p/527169#M1301853</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You are using option 'Initial selection' on Opening tab of document properties.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If you want to limit the data available to that user, you'll need to use option 'Initial data reduction'&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.qlik.com/docs/DOC-1853"&gt;Introduction to Section Access&lt;/A&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 25 Oct 2013 10:36:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/availability-of-illicit-values-Section-access/m-p/527169#M1301853</guid>
      <dc:creator>swuehl</dc:creator>
      <dc:date>2013-10-25T10:36:31Z</dc:date>
    </item>
  </channel>
</rss>

