Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am new to Qlikview. I want to know about QVD and advantages. Please explain in simple way.
Thanks in Advance
Hi Abhi,
A QVD file is a native QlikView file format optimized and compacted for speed when reading data from within a QlikView load script. Reading data from a QVD file can be 10-100 times faster than reading records directly from other data sources. A QVD file contains a single table of data from a QlikView application. While that may seem somewhat restricting remember that table can be the result of a concatenation or a join so the structure you create in the application can greatly increase its use. You can also include all calculations and manipulations in the script that creates you QVD file further increases load performance at run time.
There are several uses for a QVD file and in many cases more than one will be applicable at the same time.
• Decreasing Load Time
• Decreasing Database Server Loads
• Joining Data from Different QlikView Applications
• Incremental Data Loading