QVD

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: QVD

giakoum — Tue, 01 Nov 2016 15:45:53 GMT

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.

Re: QVD

MarcoWedel — Tue, 01 Nov 2016 20:56:07 GMT

related? how to generating the qvd file

Re: QVD

engishfaque — Wed, 02 Nov 2016 06:15:39 GMT

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);

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

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

Re: QVD

Anonymous — Wed, 02 Nov 2016 06:36:19 GMT

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.

topic Re: QVD in QlikView

QVD

Re: QVD

Re: QVD

Re: QVD

Re: QVD