topic Performance issue in QlikView https://community.qlik.com/t5/QlikView/Performance-issue/m-p/1104426#M898467 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I just asked a question on this thread : </P><P><A href="https://community.qlik.com/message/1095800" target="_blank">Problem with AGGR and MAX Value on a DateRange</A></P><P></P><P>Someone give me a good answer who worked well but when i use it on the whole data i got (around 200k row) it took more than 5mn to work. It's too long, i tried some tricks but none worked...</P><P></P><P>If someone can help me on this, i will be gratefull.</P><P></P><P>PS : To try the whole data, change the vFrom value to 31/03/2016 23:59:59.</P><P>Pps : I can't modify the database, so i have to work with it.</P><P>PPps : Maybe the solution is to do the whole calcul in script ? The script will be regenerated at night, so it's not a problem if he take some times to be ready.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Performance issue https://community.qlik.com/t5/QlikView/Performance-issue/m-p/1104426#M898467 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I just asked a question on this thread : </P><P><A href="https://community.qlik.com/message/1095800" target="_blank">Problem with AGGR and MAX Value on a DateRange</A></P><P></P><P>Someone give me a good answer who worked well but when i use it on the whole data i got (around 200k row) it took more than 5mn to work. It's too long, i tried some tricks but none worked...</P><P></P><P>If someone can help me on this, i will be gratefull.</P><P></P><P>PS : To try the whole data, change the vFrom value to 31/03/2016 23:59:59.</P><P>Pps : I can't modify the database, so i have to work with it.</P><P>PPps : Maybe the solution is to do the whole calcul in script ? The script will be regenerated at night, so it's not a problem if he take some times to be ready.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Performance-issue/m-p/1104426#M898467 2020-11-25T16:16:04Z