topic Re: QlikView Revision control / version control / source control software in QlikView

QlikView Revision control / version control / source control software

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I'm working with a solution where we use SQL server and SSIS as our data warehouse and ETL tool. The data warehouse generates most of the data for our QlikView reports.

Regarding our SSIS packeges we use the Tortoisesvn (http://tortoisesvn.tigris.org/) software for Revision control / version control / source control software, etc.

------

I'm wondering if anyone knows about software we can use for Revision control / version control / source control software for our ClikView soulution?

And tips and advices for stuff we have to think about when implenting such a solution...?

Our current sollution is not good enough where we store al qvw/qvd files on one server and with noe check-in control or "rules" for deployment and change handeling...

Hope any one can help - all advice is appreciated especially experiences anyone might have considering this issue...

QlikView Revision control / version control / source control software

StefanBackstrand — Fri, 04 May 2012 07:53:58 GMT

Take a look at the prj functionality in QlikView. Create a folder next to the document, with the same name only without ".qvw" and with added "-prj" - for example; for "Films.qvw", then name the folder "Films-prj". The next time you save the qvw document, the definition of the file with show up in xml files here. Changing the document and saving will update the xml references.

To re-create a document from the prj references, just create a blank document (Ctrl+N in QlikView), save it with the same name as the document, close it and re-open it in QlikView, and the document will be created after the definition.

Hope this helps!

QlikView Revision control / version control / source control software

mr_barriesmith — Fri, 04 May 2012 14:47:19 GMT

Agreed. We did that in QV10 and now in QV11 we tested TFS and the integration is very good.

Our experience is in the development environment only... No QVDs.

QlikView Revision control / version control / source control software

Fri, 25 May 2012 09:51:40 GMT

Hi Stefan,

Really helpfull! Just one question, what is the DocBinary.dat file? Do I need to track that as well in my version control?

Thanks

QlikView Revision control / version control / source control software

StefanBackstrand — Fri, 25 May 2012 11:51:58 GMT

I actually don't know. It's not something that I recognize..

Re: QlikView Revision control / version control / source control software

jonathandienst — Fri, 25 May 2012 12:23:04 GMT

If I recall correctly, this file contains the encrypted password and username for database connections. I am note sure what else, if anything. But yes, I would include it in your version control. I know it binary, but I have never seen it get large.

Regards

Jonathan

QlikView Revision control / version control / source control software

giakoum — Fri, 25 May 2012 12:49:58 GMT

Hi Stefan.

I am not sure I understand how this will help versioning, as every change you make, updates the xml files so there is no history.

Am I missing something here?

Thank you.

QlikView Revision control / version control / source control software

magavi_framsteg — Fri, 25 May 2012 12:56:36 GMT

This will help versioning by tracking changes made to, but not limited to:

- Changes on object properties

- Changes on sheet properties

- Changes on document properties

- Changes in the load script

- etc.

All changes made to any part of your document will be recorded in the -prj XML-files.

Thus you will be able to diff them in a diff tool.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

QlikView Revision control / version control / source control software

giakoum — Fri, 25 May 2012 13:03:33 GMT

Thank you Magnus.

so you mean to say that in the xml files changes are recorded so there is history in them. Do you have any diff tool in mind I can use to check that?

BR, Ioannis.

QlikView Revision control / version control / source control software

Fri, 25 May 2012 13:08:23 GMT

Hi,

I have three QV developers and need to be able to keep track of changes. I started testing QV10 with GIT and it looks promising.

Check these links out if you need more info

http://git-scm.com/
http://nathanj.github.com/gitguide/tour.html (recommended for newbies)

Rgdz,

Re: QlikView Revision control / version control / source control software

StefanBackstrand — Fri, 25 May 2012 13:08:44 GMT

giakoum; No, that is the responsibility of the source control system.

QlikView Revision control / version control / source control software

Fri, 25 May 2012 13:10:48 GMT

I struggle a little after recreating my document. Variables are all empty. Should I set them in my script?

QlikView Revision control / version control / source control software

StefanBackstrand — Fri, 25 May 2012 13:11:32 GMT

Yes. Data is not contained in the definitions.

QlikView Revision control / version control / source control software

jp_golay — Fri, 01 Jun 2012 08:30:14 GMT

Hi,

We just released Version Manager for QlikView, it's more than a source control tool because it can deploy your applications to the QlikView Servers.

Very simple to configure and use the tool have a long history and experience of by deployments with SAP products.

Ask for a demo at info@ebiexperts.com or http://www.ebiexperts.com

Re: QlikView Revision control / version control / source control software

maksim_senin — Wed, 19 Sep 2012 23:32:09 GMT

Hi EBI Experts,

Could you please update us on the following points:

1. Whether Version Manager stores a qvw-file (a) at whole with data (can be huge) or (b) just its textual parts (load script, xml schemes of charts, doc params, etc.) without data?

2. If the answer to the 1st question is (b), whether Version Manager stores variable defined via Version Overview dialog (Ctrl+Alt+V) in QV Developer? (the variables which are not defined in the load script)

Thanking you in advance.

Best regards,

Maxim

Re: QlikView Revision control / version control / source control software

jp_golay — Thu, 20 Sep 2012 07:43:26 GMT

1. The whole qvw is stored in VM but we have a default option to clean the data content so we can store only the app structure.

2. Yes we store all the variables (script ones and GUI ones). They are also present for versions compare and we have an option to store distincts values in VM for each target server publication

For example variable ENV = "DEV" in dev server and = "PRD" for production server. It's very useful to define different connections values before publication

Re: QlikView Revision control / version control / source control software

maksim_senin — Thu, 20 Sep 2012 07:48:37 GMT

Sounds good! But in case we put qvw under version control we loose an ability to merge/cut changes at the level of source code... anyway, thank you, will keep in mind.

Re: QlikView Revision control / version control / source control software

jp_golay — Thu, 20 Sep 2012 13:15:19 GMT

We plan to add the -prj xml files to vm in a future release and to add the diff / merge features to Version Manager comparing all xml files in one shot. Also we will keep all the variables values to VM and reinject them to the generated qvw from the -prj files after reconciliation/merge

We also wait for the opening of QV Source Control tools to others to develop an addin to QlikView

Regards, Jean-Philippe Golay CTO of ebiexperts

Re: QlikView Revision control / version control / source control software

Thu, 28 Feb 2013 18:55:03 GMT

Hi Stefan.

Create a new document and save it with the same name, but opening is still blank.

Can you tell me what my error please?

Re: QlikView Revision control / version control / source control software

Thu, 18 Jul 2013 20:46:53 GMT

Hi Jean,

Is the new release of VM is available now with the above mentioned features?

Regards,

Anosh Nathaniel