using qvd

[#1]

Hi all ;

I have 1 file , it's volume is about 300 MB,i want to know if i'm using qvd ,it help me to decrease volume of file ?

in general i want to know when the size of file related to datamodel, is using qvd help to decrease qlikview file size?

Regards,

[kaushiknsolanki]

Hi,

     QVD is no doubt help you to decrease the row data size.

     Meaning if your table size in database is 100MB then depending on the unique values QVD will compress them 80%-90%.

     Now if you want to know that which are the QVDs used in the application, then you will come to know from the script. and you can note down the QVD name and then you can actually  go to the physical location of QVD and see the QVD size from their properties.

Regards,

Kaushik Solanki

[jagan]

Hi,

Using QVD doesn't help in decrease volume of file, instead of fetching data from the datasource like (Database etc) you are going to get same data from QVD.  So, there is no difference. 

Instead check whether you are using all the fields in the tables, if not remove those fields. 

Convert DateTime to Date(mm/dd/yyyy) format this reduces the file volumn.

If you are not using decimal places truncate those decimal places by using Round/Ceil/Floor functions.

This are the different ways to reduce the volume of the file.

Regards,

Jagan.