topic Re: best method for min and max values in QlikView https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422051#M157249 <HTML><HEAD></HEAD><BODY><P>Calculate them in the script if you don't already. If that still takes to long you could try to have the source database calculate them for you. You could ask your local friendly Database Administrator for help or advice on that.</P></BODY></HTML> Fri, 08 Mar 2013 10:57:42 GMT Gysbert_Wassenaar 2013-03-08T10:57:42Z best method for min and max values https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422050#M157248 <HTML><HEAD></HEAD><BODY><P>Good day experts,</P><P>Please could yuo assist with the following. I have a table that consists of accounts and record ids(one account can have multiple record ids). I would like to find the min and max value per account, I am able to do this using min and max functions, but found that this takes quite a long time on large data sets but i do get the desired result. I would like toknow if there are other faster methods of achieving this. My table consists of 100 mil rows.</P><P></P><P>Thnak you in advance</P><P></P><P>Kind regards</P><P>Kamiel</P></BODY></HTML> Fri, 08 Mar 2013 10:51:21 GMT https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422050#M157248 kamielrajaram 2013-03-08T10:51:21Z Re: best method for min and max values https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422051#M157249 <HTML><HEAD></HEAD><BODY><P>Calculate them in the script if you don't already. If that still takes to long you could try to have the source database calculate them for you. You could ask your local friendly Database Administrator for help or advice on that.</P></BODY></HTML> Fri, 08 Mar 2013 10:57:42 GMT https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422051#M157249 Gysbert_Wassenaar 2013-03-08T10:57:42Z Re: best method for min and max values https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422052#M157250 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P>Thank you for the response. I should have mentioned that I am currently doing this in the script.</P></BODY></HTML> Fri, 08 Mar 2013 11:04:39 GMT https://community.qlik.com/t5/QlikView/best-method-for-min-and-max-values/m-p/422052#M157250 kamielrajaram 2013-03-08T11:04:39Z