topic Re: MIN value from Aggr () returns zero in QlikView https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327796#M826792 <HTML><HEAD></HEAD><BODY><P>then close the thread please...</P></BODY></HTML> Thu, 06 Jul 2017 15:48:08 GMT Anonymous 2017-07-06T15:48:08Z MIN value from Aggr () returns zero https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327793#M826789 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am new to Qlik and starts to learn with aggr function. I would like to get the minimum sales by [province] using <STRONG>Min(Aggr(Count([Order ID]), Province))</STRONG>, but it always returns zero. The correct answer should be 79. Any ideas please? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169072_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327793#M826789 Anonymous 2020-11-25T16:16:04Z Re: MIN value from Aggr () returns zero https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327794#M826790 <HTML><HEAD></HEAD><BODY><P><STRONG>try<BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><SPAN style="font-size: 14pt;">Min({&lt;Province={"=Count([Order ID])&gt;0"}&gt;} Aggr(Count([Order ID]), Province))</SPAN></P></BODY></HTML> Wed, 05 Jul 2017 07:11:12 GMT https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327794#M826790 Anonymous 2017-07-05T07:11:12Z Re: MIN value from Aggr () returns zero https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327795#M826791 <HTML><HEAD></HEAD><BODY><P>It works. Thank you so much.</P></BODY></HTML> Thu, 06 Jul 2017 07:13:12 GMT https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327795#M826791 Anonymous 2017-07-06T07:13:12Z Re: MIN value from Aggr () returns zero https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327796#M826792 <HTML><HEAD></HEAD><BODY><P>then close the thread please...</P></BODY></HTML> Thu, 06 Jul 2017 15:48:08 GMT https://community.qlik.com/t5/QlikView/MIN-value-from-Aggr-returns-zero/m-p/1327796#M826792 Anonymous 2017-07-06T15:48:08Z