topic How to compate qvd files in QlikView

How to compare qvw files

andries_bos — Wed, 07 Sep 2011 12:36:54 GMT

We have a tailered made qvw file build by a third company qlikview supplier. After installing the initial delivered qvd file, I have made some changes to the lokal installed qvd file. A week later we received an updated qvd from the third party (based on the intial delivered file).

Is the any way of detecting differences within the changes within the scripting and/or visual coding? In other words: is there any way to compare qvd files?

(My best solution for the scripting part is to save the scripting-tabs one by one as txt files and use a txt compare program.)

regards

Andries, the Netherlands, www.scancare.nl

How to compate qvd files

fosuzuki — Wed, 07 Sep 2011 17:08:50 GMT

Hi,

I think you are referring to the QVW files, not QVD, right? The QVD files only have data, not scripts...

If you are using QV10, one way of comparing QVW files is to use the '-prj' folder. Check the 'QlikView Reference Manual', topic 8.1 (QlikView Project Files) of QV10SR2. The basic idea is that you can create a folder which QlikView Desktop will use to generate some XML and TXT files, and then use a txt compare program to check the differences.

Hope this helps you

Regards,

Fernando

Re: How to compate qvd files

johnw — Thu, 08 Sep 2011 01:04:53 GMT

You probably meant comparing QVW files like Fernando says. But if you DID mean comparing QVD files, attached is an example of loading the "same" data from two different sources and then highlighting the differences.

How to compate qvd files

rwunderlich — Thu, 08 Sep 2011 01:32:16 GMT

Andries said: "(My best solution for the scripting part is to save the scripting-tabs one by one as txt files and use a txt compare program.)"

Instead of one tab at a time, you can export the entire script to a single file. In the script editor, select "File, Export to Script File".

-Rob

http://robwunderlich.com

Re: How to compate qvd files

Thu, 08 Sep 2011 03:07:07 GMT

In fact, he would like to compare the differences between the two qvd file.

How to compate qvd files

rwunderlich — Thu, 08 Sep 2011 03:15:57 GMT

You can use the various qvd script functions -- QvdNoOfRecords(), QvdNoOfFields(), QvdFieldName() -- to extract the metadata and compare the differences.

-Rob

Re: How to compate qvd files

andries_bos — Thu, 20 Oct 2011 19:00:28 GMT

You are correct. I first problem is how to compare two qvw (not qvd) files.

I actually enjoy the script export and compare these two files. Two different excellent free compare fools I have used are WinMerge and VisDiff . This will clearly highlight the differences within all script pages and one could act on them.

However I did not find any way of comparing the visual side of two qvw files. I did find that I could export the document layout (xml files) or a picture of the sheet.

A practical example : Letting someone else fine tune your app, I could not find any way to track down the (maybe one small) expression or 'front-end' value the person has changed.

any ideas on this?

Regards

Andries Bos, the Netherlands,

Re: How to compate qvd files

Anonymous — Mon, 24 Jun 2013 14:34:56 GMT

To compare the Visual side of qvws, store the files information in Project folder. For that you need to create a folder with name DashboardName-prj in the same location. On refreshing the dashboard, the information about the qvw apart from data is automatically stored in the Project folder by Qlikview.

Similarly repeat the step for other qvw.

Now using Winmerge, you can compare the xml files in those Folders.

Hope this helps

Regards,

Saurabh Pandit

Re: How to compate qvd files

quiquehm — Fri, 02 Oct 2015 16:21:20 GMT

Good stuff, as usual John !! thanks for sharing.

I have a different scenario though, where I need to compare two different files ( same fields ) and create a crosstable to highlight the changes between the two. I build a mockup in excel , find it attached here for reference. Any suggestion on how to create that crosstable ? it would be nice to be able to use the Field "Year" to select only the Delta values , so the table size is reduced, showing only what we are interested to see.

Many thanks for your help !!

Enrique