<?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 Customizable straight_table in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Customizable-straight-table/m-p/879670#M530331</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;in a new app of mine I have a straight_table that is supposed to be highly customizable.&lt;/P&gt;&lt;P&gt;- Every field in there makes sense only under specific circumstances. Otherwise, it would show a NULL value&lt;BR /&gt;&amp;nbsp;&amp;nbsp; =&amp;gt; Thus I have put that condition in a variable, that is my first condition for every field&lt;/P&gt;&lt;P&gt;- The second condition is a selection by the user - I have a customized listbox (based on an Inline table with the names of all the&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; fields), that listbox governs a set of variables and that variable (there is one for every field) also governs whether a field should&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; be displayed or not.&lt;/P&gt;&lt;P&gt;=&amp;gt; Thus I have two conditions attached to every single field.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now, the performance of this whole thing is of course an issue.&lt;/P&gt;&lt;P&gt;=&amp;gt; Thus my question: Where should I best put these two conditions:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - directly in every formula&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; OR&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - in the edit_field on the "formulas" tab&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; OR&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - on the "presentation" tab?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I guess the last one would not be ideal for that would define only whether or not to show a field, it would be calculated all the same - but it's nearly all native fields from the underlying table, there's not much to calculate, so it wouldn't really make a difference ...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks a lot!&lt;/P&gt;&lt;P&gt;Best regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DataNibbler&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 23 Jun 2015 08:42:25 GMT</pubDate>
    <dc:creator>datanibbler</dc:creator>
    <dc:date>2015-06-23T08:42:25Z</dc:date>
    <item>
      <title>Customizable straight_table</title>
      <link>https://community.qlik.com/t5/QlikView/Customizable-straight-table/m-p/879670#M530331</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;in a new app of mine I have a straight_table that is supposed to be highly customizable.&lt;/P&gt;&lt;P&gt;- Every field in there makes sense only under specific circumstances. Otherwise, it would show a NULL value&lt;BR /&gt;&amp;nbsp;&amp;nbsp; =&amp;gt; Thus I have put that condition in a variable, that is my first condition for every field&lt;/P&gt;&lt;P&gt;- The second condition is a selection by the user - I have a customized listbox (based on an Inline table with the names of all the&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; fields), that listbox governs a set of variables and that variable (there is one for every field) also governs whether a field should&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; be displayed or not.&lt;/P&gt;&lt;P&gt;=&amp;gt; Thus I have two conditions attached to every single field.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Now, the performance of this whole thing is of course an issue.&lt;/P&gt;&lt;P&gt;=&amp;gt; Thus my question: Where should I best put these two conditions:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - directly in every formula&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; OR&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - in the edit_field on the "formulas" tab&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; OR&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - on the "presentation" tab?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I guess the last one would not be ideal for that would define only whether or not to show a field, it would be calculated all the same - but it's nearly all native fields from the underlying table, there's not much to calculate, so it wouldn't really make a difference ...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks a lot!&lt;/P&gt;&lt;P&gt;Best regards,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DataNibbler&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 23 Jun 2015 08:42:25 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Customizable-straight-table/m-p/879670#M530331</guid>
      <dc:creator>datanibbler</dc:creator>
      <dc:date>2015-06-23T08:42:25Z</dc:date>
    </item>
  </channel>
</rss>

