<?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 min and max values not coming for an expression.request help please?? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683519#M1086117</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;Please help me out with below issue.&lt;/P&gt;&lt;P&gt;I have an expression&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #800080;"&gt;&lt;STRONG&gt;sum({&amp;lt;cp&amp;gt;}(Nominal_Quantity*asoff_payoff))&lt;/STRONG&gt;&lt;/SPAN&gt; which results with series of negative and positive values.&lt;/P&gt;&lt;P&gt;how do I get the min and max of the resultant&amp;nbsp; values&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;STRONG&gt;I tried min(sum({&amp;lt;cp&amp;gt;}(Nominal_Quantity*asoff_payoff)))&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;STRONG&gt;(Min(aggr(sum({&amp;lt;callput_type&amp;gt;}(Nominal_Quantity1*asoff_payoff)), market)))&amp;nbsp; but both of this doesn't work&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;something like a text box where one could give min value and the other the max value.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;SPAN style="color: #000000;"&gt;I have attached the file for reference&lt;/SPAN&gt;.&lt;SPAN style="color: #000000;"&gt;please help!!!!&lt;/SPAN&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 16 Jun 2014 02:50:36 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-06-16T02:50:36Z</dc:date>
    <item>
      <title>min and max values not coming for an expression.request help please??</title>
      <link>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683519#M1086117</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;Please help me out with below issue.&lt;/P&gt;&lt;P&gt;I have an expression&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #800080;"&gt;&lt;STRONG&gt;sum({&amp;lt;cp&amp;gt;}(Nominal_Quantity*asoff_payoff))&lt;/STRONG&gt;&lt;/SPAN&gt; which results with series of negative and positive values.&lt;/P&gt;&lt;P&gt;how do I get the min and max of the resultant&amp;nbsp; values&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;STRONG&gt;I tried min(sum({&amp;lt;cp&amp;gt;}(Nominal_Quantity*asoff_payoff)))&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;STRONG&gt;(Min(aggr(sum({&amp;lt;callput_type&amp;gt;}(Nominal_Quantity1*asoff_payoff)), market)))&amp;nbsp; but both of this doesn't work&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;something like a text box where one could give min value and the other the max value.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #ff0000;"&gt;&lt;SPAN style="color: #000000;"&gt;I have attached the file for reference&lt;/SPAN&gt;.&lt;SPAN style="color: #000000;"&gt;please help!!!!&lt;/SPAN&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Jun 2014 02:50:36 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683519#M1086117</guid>
      <dc:creator />
      <dc:date>2014-06-16T02:50:36Z</dc:date>
    </item>
    <item>
      <title>Re: min and max values not coming for an expression.request help please??</title>
      <link>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683520#M1086118</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Can't you try RangeMin(), RangeMax()?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Jun 2014 03:37:03 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683520#M1086118</guid>
      <dc:creator />
      <dc:date>2014-06-16T03:37:03Z</dc:date>
    </item>
    <item>
      <title>Re: min and max values not coming for an expression.request help please??</title>
      <link>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683521#M1086119</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;thanks for your help &lt;IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;hi I tried &lt;STRONG&gt;total&lt;/STRONG&gt;, and it worked.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 16 Jun 2014 03:39:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/min-and-max-values-not-coming-for-an-expression-request-help/m-p/683521#M1086119</guid>
      <dc:creator />
      <dc:date>2014-06-16T03:39:04Z</dc:date>
    </item>
  </channel>
</rss>

