<?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 Re: Star is *; in Section Access in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Star-is-in-Section-Access/m-p/1340463#M614644</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi christian,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;here you go:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;H1 data-mc-conditions="Targets.NotToTranslate" style="font-size: 1.714em; margin: 0 0 10px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;Star&lt;/H1&gt;&lt;P style="font-size: 14px; margin: 10px 0; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;The string used for representing the set of all the values of a field in the database can be set through the &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;star&lt;/SPAN&gt; statement. It affects the subsequent &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;LOAD&lt;/SPAN&gt; and &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;SELECT&lt;/SPAN&gt; statements.&lt;/P&gt;&lt;P class="syntax_heading" data-mc-autonum="Syntax: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;&lt;SPAN class="autonumber"&gt;Syntax: &lt;/SPAN&gt; &lt;/P&gt;&lt;P class="syntax" data-mc-conditions="Targets.NotToTranslate" style="font-size: 16px; margin: 10px 0; background-color: #f4f4f4; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; color: #0f0f0f;"&gt;&lt;SPAN class="script_token" style="font-weight: bold; font-size: 12px;"&gt;Star is&lt;/SPAN&gt;&lt;SPAN class="bnf_token" style="font-size: 12px;"&gt;[ string ]&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P class="arguments" data-mc-autonum="Arguments: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;&lt;SPAN class="autonumber"&gt;Arguments: &lt;/SPAN&gt; &lt;/P&gt;&lt;TABLE cellspacing="0" class="TableStyle-tableGrid" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px; margin-right: auto;"&gt;&lt;THEAD style="border-top: 2px solid #0f0f0f;"&gt;&lt;TR class="Head-Header1"&gt;&lt;TH class="HeadI--" style="padding: 5px 7px; text-align: left;"&gt;Argument&lt;/TH&gt;&lt;TH class="HeadG--" style="padding: 5px 7px; text-align: left;"&gt;Description&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"&gt;&lt;TR class="Body-Body1" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"&gt;&lt;TD class="BodyC--" data-mc-conditions="Targets.NotToTranslate" style="padding: 7px; border: 1px solid #d5d5d5;"&gt;string&lt;/TD&gt;&lt;TD class="BodyA--" style="padding: 7px; border: 1px solid #d5d5d5;"&gt;&lt;P style="font-size: inherit; margin: 0 0 5px;"&gt;An arbitrary text. Note that the string must be enclosed by quotation marks if it contains blanks.&lt;/P&gt;&lt;P style="font-size: inherit;"&gt;If nothing is specified, &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;star is;&lt;/SPAN&gt; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;star&lt;/SPAN&gt; statement is made.&lt;/P&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 06 Jul 2017 14:48:42 GMT</pubDate>
    <dc:creator>awhitfield</dc:creator>
    <dc:date>2017-07-06T14:48:42Z</dc:date>
    <item>
      <title>Star is *; in Section Access</title>
      <link>https://community.qlik.com/t5/QlikView/Star-is-in-Section-Access/m-p/1340462#M614643</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi, I am curious about the Star is *; Statement in Section Access, what is it doing? I am well aware of the fact, that a "*" in Section Access, does only mean that all values which are in this table available will be shown. Which is not the same as all values which are existing.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So anybody has an idea? There is also another thread, which did not answer the exact question what this statement is doing.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;&lt;STRONG&gt;Section&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Access&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;; &lt;BR /&gt; &lt;BR /&gt; [QV Auth]:&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;NoConcatenate&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt; &lt;/SPAN&gt;&lt;STRONG style=": ; color: #0000ff; font-size: 8pt;"&gt;LOAD&lt;/STRONG&gt;&lt;SPAN style="font-size: 8pt;"&gt; * &lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Resident&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt; QV_Auth_Pre;&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;&lt;BR /&gt; &lt;/SPAN&gt;&lt;STRONG style=": ; color: #0000ff; font-size: 8pt;"&gt;Section&lt;/STRONG&gt;&lt;SPAN style="font-size: 8pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;Application&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;;&lt;BR /&gt; &lt;/SPAN&gt;&lt;STRONG style=": ; color: #0000ff; font-size: 8pt;"&gt;Star&lt;/STRONG&gt;&lt;SPAN style="font-size: 8pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;is&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt; *; &lt;/SPAN&gt;&lt;SPAN style="color: #008000; font-size: 8pt;"&gt;// Required If Wildcard Characters Are Used in SA&lt;BR /&gt; &lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt;SA_REDUCTION:&lt;BR /&gt; &lt;/SPAN&gt;&lt;STRONG style=": ; color: #0000ff; font-size: 8pt;"&gt;LOAD&lt;/STRONG&gt;&lt;SPAN style="font-size: 8pt;"&gt; * &lt;/SPAN&gt;&lt;SPAN style="color: #0000ff; font-size: 8pt;"&gt;INLINE&lt;/SPAN&gt;&lt;SPAN style="font-size: 8pt;"&gt; &lt;/SPAN&gt;&lt;SPAN style="color: #800000; font-size: 8pt;"&gt;[ ...];&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 06 Jul 2017 14:44:48 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Star-is-in-Section-Access/m-p/1340462#M614643</guid>
      <dc:creator>chriys1337</dc:creator>
      <dc:date>2017-07-06T14:44:48Z</dc:date>
    </item>
    <item>
      <title>Re: Star is *; in Section Access</title>
      <link>https://community.qlik.com/t5/QlikView/Star-is-in-Section-Access/m-p/1340463#M614644</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi christian,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;here you go:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;H1 data-mc-conditions="Targets.NotToTranslate" style="font-size: 1.714em; margin: 0 0 10px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;Star&lt;/H1&gt;&lt;P style="font-size: 14px; margin: 10px 0; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;The string used for representing the set of all the values of a field in the database can be set through the &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;star&lt;/SPAN&gt; statement. It affects the subsequent &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;LOAD&lt;/SPAN&gt; and &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;SELECT&lt;/SPAN&gt; statements.&lt;/P&gt;&lt;P class="syntax_heading" data-mc-autonum="Syntax: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;&lt;SPAN class="autonumber"&gt;Syntax: &lt;/SPAN&gt; &lt;/P&gt;&lt;P class="syntax" data-mc-conditions="Targets.NotToTranslate" style="font-size: 16px; margin: 10px 0; background-color: #f4f4f4; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; color: #0f0f0f;"&gt;&lt;SPAN class="script_token" style="font-weight: bold; font-size: 12px;"&gt;Star is&lt;/SPAN&gt;&lt;SPAN class="bnf_token" style="font-size: 12px;"&gt;[ string ]&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P class="arguments" data-mc-autonum="Arguments: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"&gt;&lt;SPAN class="autonumber"&gt;Arguments: &lt;/SPAN&gt; &lt;/P&gt;&lt;TABLE cellspacing="0" class="TableStyle-tableGrid" style="margin-bottom: 15px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px; margin-right: auto;"&gt;&lt;THEAD style="border-top: 2px solid #0f0f0f;"&gt;&lt;TR class="Head-Header1"&gt;&lt;TH class="HeadI--" style="padding: 5px 7px; text-align: left;"&gt;Argument&lt;/TH&gt;&lt;TH class="HeadG--" style="padding: 5px 7px; text-align: left;"&gt;Description&lt;/TH&gt;&lt;/TR&gt;&lt;/THEAD&gt;&lt;TBODY style="border-top-width: 2px; border-top-color: #0f0f0f;"&gt;&lt;TR class="Body-Body1" style="border-bottom-width: 1px; border-bottom-color: #d5d5d5;"&gt;&lt;TD class="BodyC--" data-mc-conditions="Targets.NotToTranslate" style="padding: 7px; border: 1px solid #d5d5d5;"&gt;string&lt;/TD&gt;&lt;TD class="BodyA--" style="padding: 7px; border: 1px solid #d5d5d5;"&gt;&lt;P style="font-size: inherit; margin: 0 0 5px;"&gt;An arbitrary text. Note that the string must be enclosed by quotation marks if it contains blanks.&lt;/P&gt;&lt;P style="font-size: inherit;"&gt;If nothing is specified, &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;star is;&lt;/SPAN&gt; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new &lt;SPAN class="statement" data-mc-conditions="Targets.NotToTranslate" style="font-weight: bold;"&gt;star&lt;/SPAN&gt; statement is made.&lt;/P&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 06 Jul 2017 14:48:42 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Star-is-in-Section-Access/m-p/1340463#M614644</guid>
      <dc:creator>awhitfield</dc:creator>
      <dc:date>2017-07-06T14:48:42Z</dc:date>
    </item>
  </channel>
</rss>

