topic Re: Data source size from QVD size in QlikView https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510689#M190803 <HTML><HEAD></HEAD><BODY><P>You can get the number of rows or fields in a QVD file using:</P><P></P><P>QVDNoOfRecords('Filename')</P><P>and</P><P>QVDNoOfFields('Filename')</P><P></P><P>Might help in an estimation of data size. One times the other would give total cells, for example. Doesn't help with cardinality etc though.</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 24 Oct 2013 08:44:05 GMT Jason_Michaelides 2013-10-24T08:44:05Z Data source size from QVD size https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510685#M190799 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>is that possible to deduce the Data Source size&nbsp; from QVD size?</P><P></P><P>According to this artcle <A href="http://qlikviewnotes.blogspot.com/2011/03/qlikview-compression.html" title="http://qlikviewnotes.blogspot.com/2011/03/qlikview-compression.html">Qlikview Notes: Document Compression</A>, Data Source=10* QVD Size</P></BODY></HTML> Wed, 23 Oct 2013 09:58:04 GMT https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510685#M190799 2013-10-23T09:58:04Z Re: Data source size from QVD size https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510686#M190800 <HTML><HEAD></HEAD><BODY><P>No, not really. Suppose your source data is xml files. Then compression rate could be in the thousands.</P></BODY></HTML> Wed, 23 Oct 2013 10:08:43 GMT https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510686#M190800 Gysbert_Wassenaar 2013-10-23T10:08:43Z Re: Data source size from QVD size https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510687#M190801 <HTML><HEAD></HEAD><BODY><P>So you don't have an exact ratio??</P></BODY></HTML> Wed, 23 Oct 2013 10:22:00 GMT https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510687#M190801 2013-10-23T10:22:00Z Re: Data source size from QVD size https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510688#M190802 <HTML><HEAD></HEAD><BODY><P>Is there a way to display the size of selected data? when loading the scipt we can see only rows' number.. Any idea??</P></BODY></HTML> Thu, 24 Oct 2013 08:39:20 GMT https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510688#M190802 2013-10-24T08:39:20Z Re: Data source size from QVD size https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510689#M190803 <HTML><HEAD></HEAD><BODY><P>You can get the number of rows or fields in a QVD file using:</P><P></P><P>QVDNoOfRecords('Filename')</P><P>and</P><P>QVDNoOfFields('Filename')</P><P></P><P>Might help in an estimation of data size. One times the other would give total cells, for example. Doesn't help with cardinality etc though.</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Thu, 24 Oct 2013 08:44:05 GMT https://community.qlik.com/t5/QlikView/Data-source-size-from-QVD-size/m-p/510689#M190803 Jason_Michaelides 2013-10-24T08:44:05Z