I've been asked quite a few times about QlikView and Qlik Sense compatibilities, questions such as, how to “migrate” an app from QlikView to Qlik Sense? How compatibles are the two products? Let's explore the possibilities.
How to
The procedure to move an app from QlikView to Qlik Sense couldn’t been any simpler, you just need to drag a QVW app (QlikView file extension) and drop it into your Qlik Sense Desktop, that’s it. This will convert the QVW file into a QVF (Qlik Sense app file extension) and load the same data for you.
Please note that this process is not reversible so please make sure that you have a secure copy of the QVW file that will be converted.
Same load script
Once your file is transformed you will find that the Load Script has been ported and Qlik Sense will contain the data from the previous QVW so you can start discovering and create charts right away. That’s it, any data normalization/transformation you created in QlikView will work just fine in Qlik Sense.
However, if you hit the reload button right after an app conversion you most likely will find an error popup with a message like this:
|
LOAD statement only works with lib:// paths in this script mode
|
To solve this inconvenient and be able to reload normally you just need to recreate the connection to the data sources using Qlik Sense Data connection libraries or switch on the QlikSense Legacy mode.
Are the charts compatible?
If you have tried to convert one app from QlikView to Qlik Sense or the other way around, then you already know the answer, no they aren’t. However since expressions are fully compatible, any formula or complex expressions can simply be copied and pasted into the new environment.
Dimensions and expressions
Jacob Vinzent jvi has created an utility to get all QlikView 11 dimensions and expressions and convert them to Qlik Sense as master items. Check it out at Qlik Branch # Fasttrack QlikView to Qlik Sense.
What about variables?
If you use variables in QlikView to reduce complexity in some expressions or if your goal is to reuse expressions in multiple objects then you probably should create them as a measure in the Qlik Sense Master Library. For the rest of variables to be automatically migrated we will have to wait a little bit yet... stay tuned.
UPDATE: since the release of Qlik Sense 2.1.1 variables (both script and design) are created automatically when migrating an app from QlikView.
Can I reuse my QVDs?
Yes, you can reuse the QVDs created with QlikView and load the data really fast into Qlik Sense and the other way around.
Note: Please note this information applies to the current scenario and current versions (QV11SR2 and Qlik Sense 2.0.2)
