topic Reduce data after binary load in QlikView https://community.qlik.com/t5/QlikView/Reduce-data-after-binary-load/m-p/467944#M1152648 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I know that something similar was already posted but I can not find nothing that could help me.</P><P></P><P>So, I have upload data with Binary statement from another QVD, since it si very big dokument with so many data, i would like to agregate that huge amount of data and grouping it on for example months:</P><P></P><P></P><P>like this :</P><P></P><P></P><P>Select </P><P></P><P>Field 1,</P><P>Field 2,</P><P>Field 3,</P><P>Field 4,</P><P>month</P><P></P><P>Sum(amount)</P><P></P><P></P><P>Group by Field 1,Field 2,Field 3,Field 4, monht</P><P></P><P></P><P>What is the script for this and how this operationg not to be so memory consuming?</P><P></P><P></P><P>Thank you in advance..</P></BODY></HTML> Fri, 22 Mar 2013 08:58:08 GMT 2013-03-22T08:58:08Z Reduce data after binary load https://community.qlik.com/t5/QlikView/Reduce-data-after-binary-load/m-p/467944#M1152648 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I know that something similar was already posted but I can not find nothing that could help me.</P><P></P><P>So, I have upload data with Binary statement from another QVD, since it si very big dokument with so many data, i would like to agregate that huge amount of data and grouping it on for example months:</P><P></P><P></P><P>like this :</P><P></P><P></P><P>Select </P><P></P><P>Field 1,</P><P>Field 2,</P><P>Field 3,</P><P>Field 4,</P><P>month</P><P></P><P>Sum(amount)</P><P></P><P></P><P>Group by Field 1,Field 2,Field 3,Field 4, monht</P><P></P><P></P><P>What is the script for this and how this operationg not to be so memory consuming?</P><P></P><P></P><P>Thank you in advance..</P></BODY></HTML> Fri, 22 Mar 2013 08:58:08 GMT https://community.qlik.com/t5/QlikView/Reduce-data-after-binary-load/m-p/467944#M1152648 2013-03-22T08:58:08Z