<?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 Need Help in optimization &amp; Alternate for Multiple if Statements....? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Need-Help-in-optimization-Alternate-for-Multiple-if-Statements/m-p/887416#M309340</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;&lt;/P&gt;&lt;P&gt;Optimization for my&amp;nbsp; application become a big challenge for me, application size is&amp;nbsp; around 3GB , and Application is very slow for Clicks.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;App Details :&lt;/P&gt;&lt;P&gt;1.using String Comparisons&lt;/P&gt;&lt;P&gt;2. some aggregation function &lt;/P&gt;&lt;P&gt;3. many " if " statements for Number Conversion like K , M &amp;amp; B .&lt;/P&gt;&lt;P&gt;4. using Count(Distinct( )) in many Charts and Objects.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;EM&gt;&lt;STRONG style="color: #008000;"&gt;What are the Best Possible Optimization techniques&amp;nbsp; we can implement to replace the Above Costly and memory taking functions...?&lt;/STRONG&gt;&lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #99cc00;"&gt;&lt;EM style="color: #008000;"&gt;&lt;STRONG&gt;and also please&amp;nbsp; Send the Different Settings used to be Done in Server and QEMC to get the Better Performance&lt;/STRONG&gt;.. &lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; and also as a part of optimization technique we tried to move the major calculation into back end ( Script part) but faced few more challenges ( may be we Don't know the Exact procedure for Moving the Major Calculations into the Script ) , Please Send the Best Way to Move the Calculations to the Script part..?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any help this is highly appreciated...&lt;/P&gt;&lt;P&gt;Thanks in Advance.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 19 May 2015 12:33:49 GMT</pubDate>
    <dc:creator>vishalgoud</dc:creator>
    <dc:date>2015-05-19T12:33:49Z</dc:date>
    <item>
      <title>Need Help in optimization &amp; Alternate for Multiple if Statements....?</title>
      <link>https://community.qlik.com/t5/QlikView/Need-Help-in-optimization-Alternate-for-Multiple-if-Statements/m-p/887416#M309340</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;&lt;/P&gt;&lt;P&gt;Optimization for my&amp;nbsp; application become a big challenge for me, application size is&amp;nbsp; around 3GB , and Application is very slow for Clicks.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;App Details :&lt;/P&gt;&lt;P&gt;1.using String Comparisons&lt;/P&gt;&lt;P&gt;2. some aggregation function &lt;/P&gt;&lt;P&gt;3. many " if " statements for Number Conversion like K , M &amp;amp; B .&lt;/P&gt;&lt;P&gt;4. using Count(Distinct( )) in many Charts and Objects.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;EM&gt;&lt;STRONG style="color: #008000;"&gt;What are the Best Possible Optimization techniques&amp;nbsp; we can implement to replace the Above Costly and memory taking functions...?&lt;/STRONG&gt;&lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #99cc00;"&gt;&lt;EM style="color: #008000;"&gt;&lt;STRONG&gt;and also please&amp;nbsp; Send the Different Settings used to be Done in Server and QEMC to get the Better Performance&lt;/STRONG&gt;.. &lt;/EM&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; and also as a part of optimization technique we tried to move the major calculation into back end ( Script part) but faced few more challenges ( may be we Don't know the Exact procedure for Moving the Major Calculations into the Script ) , Please Send the Best Way to Move the Calculations to the Script part..?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any help this is highly appreciated...&lt;/P&gt;&lt;P&gt;Thanks in Advance.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 May 2015 12:33:49 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Need-Help-in-optimization-Alternate-for-Multiple-if-Statements/m-p/887416#M309340</guid>
      <dc:creator>vishalgoud</dc:creator>
      <dc:date>2015-05-19T12:33:49Z</dc:date>
    </item>
  </channel>
</rss>

