topic Re: fastest aggregation method needed in QlikView https://community.qlik.com/t5/QlikView/fastest-aggregation-method-needed/m-p/1313025#M833477 <HTML><HEAD></HEAD><BODY><P>May be using a for loop with this <A href="https://qlikviewcookbook.com/2015/05/better-calendar-scripts/" title="https://qlikviewcookbook.com/2015/05/better-calendar-scripts/">https://qlikviewcookbook.com/2015/05/better-calendar-scripts/</A></P></BODY></HTML> Mon, 05 Jun 2017 15:22:11 GMT sunny_talwar 2017-06-05T15:22:11Z fastest aggregation method needed https://community.qlik.com/t5/QlikView/fastest-aggregation-method-needed/m-p/1313024#M833476 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi ppl ,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Load Shop_id,city,&nbsp; min(orderdate) as start_date, max(orderdate) as end_date</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Resident orders_table</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">group by shop_id,city;</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">this load is taking half an hour can you people help me to reduce the load time its has&nbsp; 50 million records.</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">Thanks in advance.</SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/fastest-aggregation-method-needed/m-p/1313024#M833476 2020-11-25T16:16:04Z Re: fastest aggregation method needed https://community.qlik.com/t5/QlikView/fastest-aggregation-method-needed/m-p/1313025#M833477 <HTML><HEAD></HEAD><BODY><P>May be using a for loop with this <A href="https://qlikviewcookbook.com/2015/05/better-calendar-scripts/" title="https://qlikviewcookbook.com/2015/05/better-calendar-scripts/">https://qlikviewcookbook.com/2015/05/better-calendar-scripts/</A></P></BODY></HTML> Mon, 05 Jun 2017 15:22:11 GMT https://community.qlik.com/t5/QlikView/fastest-aggregation-method-needed/m-p/1313025#M833477 sunny_talwar 2017-06-05T15:22:11Z