Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Employee
Employee

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)


22 Comments
MVP & Luminary
MVP & Luminary

Thanks for sharing Arturo.

Regarding variables, I would suggest that even in QlikView it is a good idea to create your variables in the load script.  This way they can be re-initialised on reload, persisted when project folders are used and common variables can be created in an include file.

If variables are created this way then they will also be created in Sense after app migration.  The UI doesn't make it clear what variables you have available to you, and there is no way (AFAIK) of looking them up - but if you know the names then you are good to go with variables.

2,378 Views
Employee
Employee

Fantastic feedback. Thanks Steve!

0 Likes
2,378 Views
Contributor

and the other way around.

Afaik you can use QVD's created with QlikView 11.2 in Qlik Sense but not in the other way around because the new format of the QVD's created with Qlik Sense.

0 Likes
2,378 Views
MVP & Luminary
MVP & Luminary

This is one of the things that, I presume, will get resolved with the

imminent QlikView 12 release.

0 Likes
2,378 Views
Employee
Employee

Hey Steve and Sander,

This was actually solved in Qlik Sense 2.0 but perhaps we were lousy at communicating it

We listened to the community, thanks!, and changed the way Qlik Sense handles QVDs to promote product interoperability so now you can use a QVDs in both products regardless of where they were created.

P.S yes, optimized loads work

optimizedload.PNG

2,378 Views
MVP & Luminary
MVP & Luminary

That is good news. Thanks for sharing Alex.

0 Likes
2,378 Views
Contributor

‌I missed that one 🙂

Great !!!

0 Likes
2,378 Views
Honored Contributor II

Hi,

Very nice information. Thank you for sharing.

0 Likes
2,378 Views
Partner
Partner

Such a pity that there's no section showing all the variables as it was the case in QV. Using variables in the UI feels like a trick or a hack in QS.

2,378 Views
MVP & Luminary
MVP & Luminary

I totally get the fact that Expressions in the Repository are supposed to

take the place of variables. However, when I had created an expression for

This Month and Last Month and I wanted to get the variance by using the two

existing expressions, and I couldn't, I did wish that variables were

implemented a bit nicer.

Hopefully this is something we will see in a future version. For now SET

statements in the load script it is.

0 Likes
2,378 Views
Valued Contributor III

Nice information.

Right now i use a lot of extension like " Variable " so that i can reduce number of sheet i use in QS. the issue is extension does not support in Cloud , and i heard that new release will have variable build in , so that it will support cloud ?

As for SET analysis it need to be in load script , so that i only use YTD Flag. in the future release will this be solve ?

0 Likes
2,378 Views
Employee
Employee

‌luckily variables will be available in the UI starting from 2.1

0 Likes
2,378 Views
Partner
Partner

Woohoo!!

0 Likes
2,378 Views
Employee
Employee

Alex... Spoiler alert!

0 Likes
2,378 Views
MVP & Luminary
MVP & Luminary

Yay!

That is good to hear.

2,378 Views
Employee
Employee

We are also looking into how to be able to leverage the library even more, for example be able to reference measures inside measures etc.

However we really want to make sure we get it right from the start, you include dependencies so what should happen to a measure that depends on another measure when the dependent measure is changed or deleted for example. Lot's of really interesting pitfalls that needs to be sorted out

0 Likes
2,378 Views
MVP & Luminary
MVP & Luminary

Hi Alexander,

I would say that if the implementation of variables is there as an advanced under the bonnet way of implementing complex expressions, with the ability to nest variables as you can in QlikView, then that ticks the box.  Advanced users can build anything they need whilst more 'point and click' type users are protected from tripping themselves up due to a cyclic reference in a Measure.

Just my humble opinion though.

BTW, really gutted that I am unlikely to be able to get along to the Dev Group in a couple of weeks.  It will be the first one I've missed.  The change of date pushed it from a day I had kept clear for working in London to a day I had already booked up elsewhere.

0 Likes
2,378 Views
Partner
Partner

Sorry Steve - the venue forced the date change! Are you sure you won't make it!?

0 Likes
2,378 Views
MVP & Luminary
MVP & Luminary

I'm doing QlikView training in the metropolis of Bracknell until COB.  It's a horribly slow train line into town. I could arrive fashionably late - but probably too late to make it worthwhile.  I can try delivering some really heavy set analysis material early afternoon and hope the delegates cry off early...

0 Likes
2,378 Views
Valued Contributor

Thanks for sharing this information about the migration.

0 Likes
2,378 Views
Partner
Partner

Thanks for sharing

0 Likes
2,378 Views
Partner
Partner

Great explanation!!

In case you want to check out a live demo:  We recently conducted a webinar which included the steps on How to convert a QlikView app to Qlik Sense using QlikView converter utility.

Hope you find it useful.

0 Likes
2,183 Views
Labels