topic Need to optimise performance in QlikView https://community.qlik.com/t5/QlikView/Need-to-optimise-performance/m-p/207833#M1208712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have some scripts in my application which takes longer time to load.</P><P>example:</P><P>for i = 1 to 365</P><P>load</P><P>f1,f2,f3,f4,f5,</P><P>$(i) as day,</P><P>sum (if($(i) &lt; f1,f3,0) as g3</P><P>group by</P><P></P><P>f1,f2,f3,f4,f5;</P><P>How can I optimise this...?</P><P>Group by takes more time...</P><P></P><P></P><P></P></BODY></HTML> Tue, 05 Jan 2010 06:45:56 GMT 2010-01-05T06:45:56Z Need to optimise performance https://community.qlik.com/t5/QlikView/Need-to-optimise-performance/m-p/207833#M1208712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have some scripts in my application which takes longer time to load.</P><P>example:</P><P>for i = 1 to 365</P><P>load</P><P>f1,f2,f3,f4,f5,</P><P>$(i) as day,</P><P>sum (if($(i) &lt; f1,f3,0) as g3</P><P>group by</P><P></P><P>f1,f2,f3,f4,f5;</P><P>How can I optimise this...?</P><P>Group by takes more time...</P><P></P><P></P><P></P></BODY></HTML> Tue, 05 Jan 2010 06:45:56 GMT https://community.qlik.com/t5/QlikView/Need-to-optimise-performance/m-p/207833#M1208712 2010-01-05T06:45:56Z Need to optimise performance https://community.qlik.com/t5/QlikView/Need-to-optimise-performance/m-p/207834#M1208713 <HTML><HEAD></HEAD><BODY><P>Is there a specific reason you need the group by?</P><P>I have never needed to use a GROUP BY with QV, since you can do that in the tables/chart easily. But I don't know the background of your request of course <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Sun, 10 Jan 2010 23:27:45 GMT https://community.qlik.com/t5/QlikView/Need-to-optimise-performance/m-p/207834#M1208713 2010-01-10T23:27:45Z