QVD

[#1]

Hi Guys,

Is There a types of QVD such as Raw QVD and Model QVD

Raw QVD -  QVD with out any Transformation

Model QVD -  QVD with Transformations

I searched in google and found no results, So guys is there a Topic Such as This.

Tanhks In Advance

Regards,

John

[giakoum]

QVDs are used to store data (1 table) in a Qlik format file.

So it is totally up to the developer if it is raw or transformed data in there.

[MarcoWedel]

related?  how to generating the qvd file

[engishfaque · Accepted solution]

Hi John,

There is no concept of raw QVD or Model QVD in QlikView.

We have only one QlikView Data File (QVD), either it is created by Extraction Layer, Transformation Layer, Visualization Layer or created by QlikView Management Console.

We have two mode to read QVD file into QlikView, description and examples are given below,

1. Optimized mode (fastest mode): Loading data straight forward, there is no transformation or any field renaming.

    productSales:

    LOAD * Inline [

        Product, Sales

        A, 100

        B, 20

        C, 30

    ];

2. Standard mode (fast mode): Loading data with performing transformation over the fields or renaming fields.

    productSales:

    LOAD Product as myProductField, Sales as myProductSales Inline [

        Product, Sales

        A, 100

        B, 20

        C, 30

    ];

Here are the ways to Create QVD file in QlikView,

1. QVD creation by QVW

    productSales:

    LOAD * Inline [

        Product, Sales

        A, 100

        B, 20

        C, 30

    ];

    STORE Product from productSales into C:\Datastore\QVD\productSales.qvd (qvd);

    OR

    STORE productSales into C:\Datastore\QVD\productSales.qvd (qvd);

    OR

    STORE * from productSales into C:\Datastore\QVD\productSales.qvd (qvd);

2. QVD creation by QlikView Management Console (QMC)

    Inserting the QVD generation script as a task in System > Supporting Tasks > QVD Generation

    Enter information in the Basics and Parameters fields, and click on Apply

Please check,

how to generating the qvd file

Kind regards,

Ishfaque Ahmed

[Anonymous]

I have not come across this concept but it should be fine if you would like to set that naming convention as a standard in your environment.