topic How to reduce the data in a QVD in QlikView https://community.qlik.com/t5/QlikView/How-to-reduce-the-data-in-a-QVD/m-p/185373#M49894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would advise you split your QVD into multiple QVD's with the same name and suffix with the YearMonth. For example if you have one big ledger table, you can split that into multiple QVD's withe the names Ledger2010Jan and etc.</P><P>While loading your data into QVD you can pick the QVD's you need to load the required month's data into the memory.</P><P>Hope this helps.</P><P>Regards,</P><P>Murali</P></BODY></HTML> Mon, 28 Mar 2011 18:35:45 GMT 2011-03-28T18:35:45Z How to reduce the data in a QVD https://community.qlik.com/t5/QlikView/How-to-reduce-the-data-in-a-QVD/m-p/185372#M49893 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P style="margin: 0in 0in 10pt;">We have a QVD which will have only 39 months of data and our goal is to have the data from the 40 month dropped of the QVD every month.</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Our current QVD has more than 53 million of rows and 247 columns. We tried using the WHERE clause to filter the rows but it took around 5 hrs. To get the new QVD done, also we tried doing an INNER JOIN with only the rows we want but it took almost 3 hrs.</P><P style="margin: 0in 0in 10pt;">We are looking for other options so we want to hear from the community more ideas on how to get this done.</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Thanks to all.</P><P></P></BODY></HTML> Mon, 28 Mar 2011 18:25:26 GMT https://community.qlik.com/t5/QlikView/How-to-reduce-the-data-in-a-QVD/m-p/185372#M49893 Anonymous 2011-03-28T18:25:26Z How to reduce the data in a QVD https://community.qlik.com/t5/QlikView/How-to-reduce-the-data-in-a-QVD/m-p/185373#M49894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would advise you split your QVD into multiple QVD's with the same name and suffix with the YearMonth. For example if you have one big ledger table, you can split that into multiple QVD's withe the names Ledger2010Jan and etc.</P><P>While loading your data into QVD you can pick the QVD's you need to load the required month's data into the memory.</P><P>Hope this helps.</P><P>Regards,</P><P>Murali</P></BODY></HTML> Mon, 28 Mar 2011 18:35:45 GMT https://community.qlik.com/t5/QlikView/How-to-reduce-the-data-in-a-QVD/m-p/185373#M49894 2011-03-28T18:35:45Z