topic Re: QVD Design in QlikView

QVD Design

Wed, 28 Aug 2013 10:14:30 GMT

Hi,

We have a number of QVD files, created by a former employee 2 or 3 years ago. Within these QVD files, various fields have been concatenated/had logic applied, and then renamed as something else.

Unfortunately whilst I know there are tools out there, like QViewer, that will let me view the contents of a QVD file, I can't seem to find a tool that will let me see the actual design of the QVD file. I need to see the logic used to create the fields in the QVD file, not the resulting data.

Can someone enlighten me? Many thanks, Gavin

Re: QVD Design

rajeshvaswani77 — Wed, 28 Aug 2013 10:16:53 GMT

There will be a QVW File that would have been used to create teh QVD's. If you get hold of that file then that has all the logic you are lookign for.

thanks,

Rajesh Vaswani

Re: QVD Design

Wed, 28 Aug 2013 10:28:38 GMT

Thanks Rajesh. The implication of your response is that if we don't have the original .qvw then it's not possible to view the design of the .qvd?

Thanks, Gavin

Re: QVD Design

narender123 — Wed, 28 Aug 2013 10:32:32 GMT

Hi,

The Qvd files are created by Qvw.

Normally we call it Qlikview generator for generating Qvd files.So you need to see that Qv generator(.qvw file) .

Thanks.

Narender

Re: QVD Design

techvarun — Wed, 28 Aug 2013 10:32:35 GMT

Hello

QVD is just like a snapshot of the Data-source. and you must have the qvw file to analyse what's the logic used in your application

Regards

Re: QVD Design

techvarun — Wed, 28 Aug 2013 10:34:27 GMT

if the number of records are low then u can match the qvd values with the output and requirement document

Regards

Re: QVD Design

rajeshvaswani77 — Wed, 28 Aug 2013 10:38:02 GMT

Yes Gavin. Thats right.

thanks,

-RV

Re: QVD Design

Wed, 28 Aug 2013 10:43:21 GMT

Thank you all, this makes sense.

Re: QVD Design

narender123 — Wed, 28 Aug 2013 10:44:15 GMT

Hi Gavin,

Normally we take the qv generator to generate the qvd(for load optimization).After that we create the qvw file that will take the qvd.So mainly all logic is in your qvw file not qv generator.If u say it is in your qv generator then definetly you have because qv generator file for load latest data form database via odbc connection.

Thanks.

Narender