topic Aggregate On Concatenated QVDs in QlikView https://community.qlik.com/t5/QlikView/Aggregate-On-Concatenated-QVDs/m-p/431578#M160906 <HTML><HEAD></HEAD><BODY><P>I get QVDs each month, the average size is about 370 MB. Currently, this is how I'm dealing with these files.</P><P></P><P>Concatenate all available QVDs generated on monthly basis to get one big QVD</P><P>Then, do Count/Aggregate functions and get result-set in a separate QVD</P><P>Link the resulting QVD to main data model</P><P></P><P>Is there a better way to handle this situation ? I'm more concerend about the size and the time it takes to execute. Should I go for incremental reload ?</P></BODY></HTML> Mon, 03 Jun 2013 02:00:13 GMT Anonymous 2013-06-03T02:00:13Z Aggregate On Concatenated QVDs https://community.qlik.com/t5/QlikView/Aggregate-On-Concatenated-QVDs/m-p/431578#M160906 <HTML><HEAD></HEAD><BODY><P>I get QVDs each month, the average size is about 370 MB. Currently, this is how I'm dealing with these files.</P><P></P><P>Concatenate all available QVDs generated on monthly basis to get one big QVD</P><P>Then, do Count/Aggregate functions and get result-set in a separate QVD</P><P>Link the resulting QVD to main data model</P><P></P><P>Is there a better way to handle this situation ? I'm more concerend about the size and the time it takes to execute. Should I go for incremental reload ?</P></BODY></HTML> Mon, 03 Jun 2013 02:00:13 GMT https://community.qlik.com/t5/QlikView/Aggregate-On-Concatenated-QVDs/m-p/431578#M160906 Anonymous 2013-06-03T02:00:13Z Re: Aggregate On Concatenated QVDs https://community.qlik.com/t5/QlikView/Aggregate-On-Concatenated-QVDs/m-p/431579#M160907 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Incremental reload is one of the best approach if your concern is size and execution time. Instead of concatinating all of your QVDs, you can use mapping load for tables with 2 fields. This will lessen the number of QVDs you have.</P><P></P><P>Regards,</P><P></P><P>Janzen</P></BODY></HTML> Mon, 03 Jun 2013 03:21:39 GMT https://community.qlik.com/t5/QlikView/Aggregate-On-Concatenated-QVDs/m-p/431579#M160907 2013-06-03T03:21:39Z