How to compare qvw files

[andriesb]

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

[fosuzuki]

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

[johnw]

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.

[rwunderlich]

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

[#5]

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

[rwunderlich]

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

-Rob

[andriesb · Accepted solution]

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,

[Anonymous]

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

[quiquehm]

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