topic Re: Why does my MIN value from an AGGR return a different result compared to the table result? in QlikView https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925854#M320393 <HTML><HEAD></HEAD><BODY><P>Because of the load order of your Month field. Apr is probably the first month encountered in your source data.</P></BODY></HTML> Tue, 03 Nov 2015 12:46:38 GMT Gysbert_Wassenaar 2015-11-03T12:46:38Z Why does my MIN value from an AGGR return a different result compared to the table result? https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925852#M320391 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>For the Min value I get 102365... as a number when the number expected is 1187,991 that you can see in the last expression of the RangeSum column.</P><P></P><P>Anyone know why this is?</P><P></P><P>In the example 2 I get a perfectly correct output as Min so I am not sure why the difference in result for example 1.</P><P></P><P>Any help please?</P></BODY></HTML> Tue, 03 Nov 2015 12:33:12 GMT https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925852#M320391 jblomqvist 2015-11-03T12:33:12Z Re: Why does my MIN value from an AGGR return a different result compared to the table result? https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925853#M320392 <HTML><HEAD></HEAD><BODY><P>Can you share a qvw where we can see this behavior?</P></BODY></HTML> Tue, 03 Nov 2015 12:44:23 GMT https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925853#M320392 sunny_talwar 2015-11-03T12:44:23Z Re: Why does my MIN value from an AGGR return a different result compared to the table result? https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925854#M320393 <HTML><HEAD></HEAD><BODY><P>Because of the load order of your Month field. Apr is probably the first month encountered in your source data.</P></BODY></HTML> Tue, 03 Nov 2015 12:46:38 GMT https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925854#M320393 Gysbert_Wassenaar 2015-11-03T12:46:38Z Re: Why does my MIN value from an AGGR return a different result compared to the table result? https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925855#M320394 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert I see your point because April contains that exact number if I do Sum(Sales), but should it not still return 1187,991 because it is the minimum value from my rangesum expression?</P><P></P><P>Maybe I do not understand something about this.</P></BODY></HTML> Tue, 03 Nov 2015 12:54:22 GMT https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925855#M320394 jblomqvist 2015-11-03T12:54:22Z Re: Why does my MIN value from an AGGR return a different result compared to the table result? https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925856#M320395 <HTML><HEAD></HEAD><BODY><P>That's only the minimum number if you order your dimension in chronological order, as shown in the chart.</P><P>Try sorting the dimension in load order (sort tab), like the aggr() function will sort its dimension values.</P><P></P><P>The aggr() function will not necessarily use the same dimension sort order as your chart!</P></BODY></HTML> Tue, 03 Nov 2015 13:04:00 GMT https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925856#M320395 swuehl 2015-11-03T13:04:00Z Re: Why does my MIN value from an AGGR return a different result compared to the table result? https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925857#M320396 <HTML><HEAD></HEAD><BODY><P>Thank you I understand now and changed the order of Months and it works.</P><P></P><P>Very good lesson.</P></BODY></HTML> Tue, 03 Nov 2015 14:05:55 GMT https://community.qlik.com/t5/QlikView/Why-does-my-MIN-value-from-an-AGGR-return-a-different-result/m-p/925857#M320396 jblomqvist 2015-11-03T14:05:55Z